Access V1.X

Recent Posts

• Excel Import
  • Is it possible to import information from an excel document and then retrieve information pertaining to the items in the excel document? For example: If I am given an excel document with various SSN's on it, is there a way that I could import that into a database and then pull information on those SSN's? I'm sorry if I'm not being 100% clear. I am using Access 2003 on Windows XP.-- NO STEVE, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE".
    page tag? Access V1.X UtfBTkFT
• Email Form As Pdf Using Lotus Notes
  • I am trying to email a report from Access 2007I select eMail then SEND OBJECT AS report.PDFThe system initiates a new email through Lotus Notes 6.5.5 and attaches report.XLS. XLS not PDF....This file will not open in Excel. I have to save the file, change the extension back to PDF, then send it.Why would the extension automatically change? How can I stop this from happening?Thanks,Michael
    page tag? Access V1.X UtfBbWlrZWFyZWxsaQ
• Forms Disappearing
  • I am working in access 2007 I was working in a form and all of the information in the form disappeared. I closed down and restarted-nothing. When I tried to build a new form it disappears as well. It shows up in design mode but not in any other mode. Any ideas?
    page tag? Access V1.X UtfBeWyallbGZXIwMg
• Sofia Talentos ( Procura Talentos )
  • ATENÇÃO: EU MARIA SOFIA FILHA DE JOSE PRAXEDES ESTOU FAZENDO UM SHOW DE TALENTOS OBRIGADA PELA A ATENÇÃO
    page tag? Access V1.X isoQJosEPraxedes
• Compatability Pack
  • I have 2003 version of Word. Installed new hard drive so lost all. Which compatability pack is needed to view 2007 Word documents.
    page tag? Access V1.X UtfBSmluZXk
• Experimenting With News Groups
  • No need to reply - just testing with New Groups
    page tag? Access V1.X Chelsea
• Can Anyone Explain This Intolerable Latency On A Wan?
  • I have some clients (there are about six team members) working on anAccess 2003 Front End which is connected by a WAN to an Access 2003Back End some hundred or so miles away.When the application starts there are some housekeeping operationsthat take place (some once a day when the first person logs on, otherswhen anyone logs on) before the initial screen is displayed. When theback-end used to be hosted locally the time to display the firstscreen was a matter of five or ten seconds. Now that the back-end ison the WAN it typically takes TWENTY FIVE MINUTES before the firstscreen is displayed.I've tested the network connection by copying the back-end database inits entirety onto a local machine. It's only 55 Mb and the copy tookabout 55 seconds. I've also configured the application to connect tothe local copy and it runs much, much quicker.Since the network connection *seems* ok, can anyone suggest any otherpossible candidates for the unusable latency that my clients areexperiencing? They are a small team in an enormous organisation witha very uncooperative IT Support department.ThanksEdward
    page tag? Access V1.X Edward
• Field Types
  • Hi allI am creating a search form, I have populated a combo box in the header with the row source based on Field list from a query (aliases of real field names). How can I add an extra column to this containing each fields data types, so I can use this somehow in a filter in vba? I have a lot of fields so I want to be able to use one text box as search criteria which can be used to enter text, number or a date etc.Thanks in advance for any help.
    page tag? Access V1.X UtfBaHVnaGVzczc
• Main / Sub Form
  • I have a main form, the user selects the criteria and passes the parameter to the underlying query of the subform how do I refresh the sub form.
    page tag? Access V1.X UtfBTyuLi
• Count Number Of Items In A Listbox
  • Hello,I am new to Access. I have a form with a list box named lstProject that gets it data from a table (table_Project). The list box works fine. It shows all of my desired results. I would like to place a textbox (txtCount) underneath the listbox to count how many records appear in the list box.Is there an easy way to do this? I was not sure what code I would need to put in.
    page tag? Access V1.X UtfBQlpleWdlcg
• Outlook Email Content Linked To Ms Access
  • I can link an outlook folder to a table in Access, I get all the fieldand most of the data in the fields but the messege content (body txt)does not show. The fields are there in the table just empty. What am idoing wrong.
    page tag? Access V1.X John Nipper
• Can Field Names In A Table Dropdown Be Alphabetical?
  • Is there a way to get the field names in tables to appear alphabetical when working in a query?
    page tag? Access V1.X UtfBcmFwaWibNb
• Open Multiple Instances On One Pc...
  • Hi,We have a bunch of access adps used as front ends for SQL server databases and recently converted to Access 2007. The problem is that Access 2007 apparently wants to modify the adp which is causing two issues.First, because the adp is opened for writing, attempting to open a second instance forces the second instance to be opened in "read only" mode which displays a save as dialog to save a copy of the adp under a different name. Because it's connected to an SQL server for data storage, there is nothing in the adp that should be changed...so opening in read only mode would be fine if not for the warning message and "save as" option. In fact...opening in read only mode would fix the secon issue...The second issue is that we use a "loader app" which examines the date/time stamp of the adp to determine if it's the latest version. Since the file is always opened for reading...the file date/time stamp gets updated every time the adp is opened. That is interfering with our ability to determine if there is a newer version available.So...what I'm looking for is a means to suppress the read only warning. I can understand displaying a warning if it's opening the file as read only because of a file lock. But if I'm opening the file read only by using the "/ro" command line switch, do I really need a warning? It seems silly to warn me about something that I'm obviously doing deliberately. And it's down right aggravating when there is no way to override that warning.
    page tag? Access V1.X UtfBUmF
• Storing Images In Access
  • I've read lots of posts recommending not to store images in an Access database, and I usually just store pointers to the images. However, I'm trying to figure out whether it is possible to store the images in the db and extract them from the db at runtime.Specifically, I am working on an application which, among other things, creates several different PowerPoint slides (this is working pretty well so far). Now, I have to figure out a way to put these images in the upper left and right corners of the document, without deploying a .ppt template. So, the first step is to figure out how to store and retrieve these images.I also use these images in multiple Access reports and forms, so storing the image and then filling (somehow) the Access report and form image controls when these forms or reports are loaded would significantly reduce the size of my Access application.Is this a stupid idea? If not, what are my options?----Dale
    page tag? Access V1.X UtfBRGFsZSBGeWU
• Two Different Characters In String
  • Hello,I am using Access 2003 and trying to create a query that separates the last name from a field of last name/first name combo. My data can look like thisJones, Adamor can look like this:Jones|AdamI currently use Left(qryMHTracking!LName,InStr(qryMHTracking!LName,",")-1) which does fine for the names with a comma in them. I cannot seem to find a way where I can evaluate both instances (, and |) to yield the last name by itself.Any help?
    page tag? Access V1.X UtfBUFQMg
• Row Height (Different For Each Row)
  • I am collecting data, example:record1: "this is a short sentence"record2: "this is a longer sentence that will need to wrap when displayed..."record3: "another short sentence"I would like to display them on a continous form with the text field above and a few buttons (on each row)However I would like each row to grow to the appropriate size to display the text.So the user would see three rows and the middle one would have a larger row height than the other two.The buttons on the form would allow the user to open the record, and do other operationsNote: I'm trying to simplify what is needed a bit.I'm having a brain fart today, and can't figure out a good way to display records that have various sizes (and I want the entire text to be shown).Access2007, can't use any third party controls.I tried the CanGrow property.Any help is appreciated,Mark
    page tag? Access V1.X Mark Andrews
• Trial
  • hi lennox
    page tag? Access V1.X Craigs
• Access Database Deleting
  • how to remove the first word "only" in a cell. example: and also who ever sends me an e-mail is my friends so send. I would like to remove the first word "and". the other issue is that not all the cells begin with the same word. Is this possible to do. I am new to this so i could use the help
    page tag? Access V1.X UtfBamVYW
• Filter Query
  • I have a query that contains SSN's. The SSN's contain 10 characters, the first being a designator for branch of service or civilian. For example, SSN's beginning with "0" belong to Marines, while SSN's starting with "N" are Navy. What I need to do is filter out all Navy and Civilian personnel and show only Marines. I have tried what I thought would work in the criteria row but nothing is working. Please advise. Thank you.-- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE".
    page tag? Access V1.X UtfBTkFT
• How Do I Cahnge My Profile?
  • I ahve a new e-mail and I need to phase out my old e-mail.Where do I change my e-mail to sign in to the Microsoft websites Newsgroups that I visit occasionally using Intternet Explorer?Thanks in advance.
    page tag? Access V1.X UtfBTNYXZpbw
• Setting Focus After Error
  • If they try to enter a record without a selection in the parent form I need to return them to the main form - I have tried different ways but none work - this is my current tryPrivate Sub ModelName_Enter() Dim StrName As String Dim i As Integer Dim Msg As String StrName = Nz(Me.Parent![VehName]) If StrName = "" Then GoTo 100 GoTo 200100 Msg = "'" & "' No Vehicle Name is Selected." Msg = Msg & " - Select Vehicle Name" i = MsgBox(Msg, vbQuestion + vbYesonly, "Unknown Vehicle...") Response = acDataErrContinue Forms!vehicle!VehName.SetFocus200 Exit SubEnd SubWhen it returns it goes to the field ON THE SUBFORM that it started in - not the parent form
    page tag? Access V1.X UtfBTnlsZXg
• Messages Received
  • We have received three messages from you thus far.I'm glad you found a good reataurant.I'd stick with them as much as possible.We went to Billy's for our anniversary. I ordered the most expensive item ($15) on thetwighlight menu. It wa sea food au gratin. It contained only two small shrimp and the restwas baked cheese. I told the waiter they forgot the sea food. He said that is all youget on the twighlight menu and that there was shredded crab in the cheese sauce.That is the end of Billy's. The bill and tip came to $35 and all I ate was two very small shrimp. Love, Dad
    page tag? Access V1.X Richard Fitzpatrick
• Having Trouble With Percentages
  • I am inputting data on the table and for some reason when i set the format to number and percentage anytime i put in a percent (i.e. 94) it automatically changes it to 100%Anyone know how to fix this( im new to access so a step by step would be helpfulThanks alot everyone
    page tag? Access V1.X UtfBQmxZWxpbmVyOTc
• Filter Subform
  • After selecting a name from my dropdown box (top of form) the subform updates and reflects all records by that name. Can I add two boxes to reflect the subform by by month or by upc? (access 2003)I just want to use one of the choices at a time, reflect subform information by name, by month, or by upc...Thank You for your time.
    page tag? Access V1.X UtfBSHVtYmxlZCBMZWFybmVy
• Field/Column Limit
  • Dear,My query will produce a table of 2,000 Fields and 10,000 rows. Is there any way to extend field/column limitation in Acess? Thanks,Pemt
    page tag? Access V1.X UtfBcGVtdA
• Is This Possible ??
  • Hello guys,I have a text field with descriptions as follows:SPOT TWIST GU10 50W BLIS 16751LAMPTB 400W E40 GE MHL 30052I want to format them as such so that the last 5 digits of the string diplay as follows:SPOT TWIST GU10 50W BLIS *****LAMPTB 400W E40 GE MHL ***** How should I do this?Thanks in advance!
    page tag? Access V1.X UtfBRWFybCBSEgSiBbGxhZGllbiBpbiBhYNlcMgZmydWhIQ
• Not In List Event Problem
  • I'm trying to set up where a a form is used to update a master record. This forms has a combo box to select a client. I want to update the table that that supports the combo box when an entry is made that is not on the table.I'm using the Not in List event and the following code:Private Sub Client_Name_NotInList(NewData As String, Response As Integer) Dim strTmp As String ' Get confirmation that this is not just a spelling error. strTmp = "Add '" & NewData & "' as a new Client?" If MsgBox(strTmp, vbYesNo + vbDefaultButton2 + vbQuestion, "Not in List") = vbYes Then ' Append the NewData as a record in the Clients table. strTmp = "INSERT INTO Clients ( CLIENT NAME ) " & _ "SELECT """ & NewData & """ AS CLIENT NAME;" DBEngine(0)(0).Execute strTmp, dbFailOnError 'Notify Access about the new record, so it requeries the combo. Response = acDataErrAdded End If End SubI get a Run-time error '3134' and Syntax error in INSERT INTO statement.I can not see or find the syntax error. Please help.
    page tag? Access V1.X Bills
• Mail Merge Into Ms Word
  • I used this site to get examples of Mail Merge code. Below you will find my existing code that works just fine. It is used to print graduation certificates for classes. The problem is the boss does not like the idea that up to 24 different word docs get opened instead of one big combined document. Everytime I try to change something I just get into more trouble. I have a MS Word templete that I use to big the certificates. Should I make a templete with upto 24 grad certificates in it? There just seems there should be an easier answer. Thank you for any help you can provide.If Me.optCert = -1 Then Set mysetgrad = db.OpenRecordset("tblGradRoster", DB_OPEN_TABLE) ' Open table for reading. Debug.Print mysetgrad.RecordCount iSSN = mysetgrad![SSN] Do Until mysetgrad.EOF If mysetgrad!PrintCERT Then ' Refresh querydefs collection db.QueryDefs.Refresh DoCmd.SetWarnings False strSQL = "SELECT [tblACO new].SSN, Right([tblACO new]!SSN,4) AS LAST4, [tblACO new].LNAME, [tblACO new].FNAME, " strSQL = strSQL & "[tblACO new].MI , [tblACO new].SUFFIX, tblGradRoster.COURSE, tblGradRoster.CLASSNO, " strSQL = strSQL & "[tblSchool Schedule new].GRADUATE, [tblGrade new].[Long Title], tblGradRoster.TITLE, " strSQL = strSQL & "tblGradRoster.PMOS, tblGradRoster.CID, tblGradRoster.[CE ID], tblGradRoster.Version, " strSQL = strSQL & "tblGradRoster.Length, tblGradRoster.EXHIBIT, tblGradRoster.LEARNING, tblGradRoster.INST, " strSQL = strSQL & "tblGradRoster.CRED, tblGradRoster.CREDIT, tblGradRoster.CREDIT1, tblGradRoster.CREDIT2, " strSQL = strSQL & "tblGradRoster.CREDIT3 , tblGradRoster.CREDIT4, tblGradRoster.CREDIT5, tblGradRoster.CREDIT6, " strSQL = strSQL & "tblGradRoster.MILGUIDE, tblGradRoster.MILGUIDEWEB, tblGradRoster.Revision " strSQL = strSQL & "FROM [tblSchool Schedule new] INNER JOIN (tblGradRoster INNER JOIN ([tblGrade new] INNER JOIN " strSQL = strSQL & "[tblACO new] ON [tblGrade new].Rank = [tblACO new].RANK) ON tblGradRoster.SSN = [tblACO new].SSN) " strSQL = strSQL & "ON ([tblSchool Schedule new].COURSE = [tblACO new].COURSE) AND ([tblSchool Schedule new].CLASS = " strSQL = strSQL & "[tblACO new].CLASSNO) AND ([tblSchool Schedule new].COURSE = tblGradRoster.COURSE) AND " strSQL = strSQL & "([tblSchool Schedule new].CLASS = tblGradRoster.CLASSNO) " strSQL = strSQL & "WHERE ((([tblACO new].SSN)= " & iSSN & "));" Debug.Print strSQL Set rst = CurrentDb.OpenRecordset(strSQL) With rst If Nz(.Fields("MI")) = "" Then If Nz(.Fields("SUFFIX")) = "" Then strName = Nz(.Fields("LONG TITLE")) & " " & Nz(.Fields("FNAME")) & " " & Nz(.Fields("LNAME")) & " XXX XX " & Nz(.Fields("LAST4")) & "/" & Nz(.Fields("PMOS")) Else strName = Nz(.Fields("LONG TITLE")) & " " & Nz(.Fields("FNAME")) & " " & Nz(.Fields("LNAME")) & " " & Nz(.Fields("SUFFIX")) & " XXX XX " & Nz(.Fields("LAST4")) & "/" & Nz(.Fields("PMOS")) End If Else If Nz(.Fields("SUFFIX")) = "" Then strName = Nz(.Fields("LONG TITLE")) & " " & Nz(.Fields("FNAME")) & " " & Nz(.Fields("MI")) & " " & Nz(.Fields("LNAME")) & " XXX XX " & Nz(.Fields("LAST4")) & "/" & Nz(.Fields("PMOS")) Else strName = Nz(.Fields("LONG TITLE")) & " " & Nz(.Fields("FNAME")) & " " & Nz(.Fields("MI")) & " " & Nz(.Fields("LNAME")) & " " & Nz(.Fields("SUFFIX")) & " XXX XX " & Nz(.Fields("LAST4")) & "/" & Nz(.Fields("PMOS")) End If End If strCOURSE = Nz(.Fields("TITLE")) strCOURSE1 = Nz(.Fields("TITLE")) strCOURSE2 = Nz(.Fields("TITLE")) strCLASSNO = Nz(.Fields("CLASSNO")) strDAY = Nz(.Fields("GRADUATE")) strMONTH = Nz(.Fields("GRADUATE")) strYEAR = Nz(.Fields("GRADUATE")) strACE = Nz(.Fields("CE ID")) strCID = Nz(.Fields("CID")) strVERSION = "Version " & Nz(.Fields("VERSION")) & ": " & Mid$(strCID, 4, 3) strLENGTH = Nz(.Fields("LENGTH")) strEXHIBIT = Nz(.Fields("EXHIBIT")) strLEARNING = Nz(.Fields("LEARNING")) strINST = Nz(.Fields("INST")) strCRED = Nz(.Fields("CRED")) strCREDIT = Nz(.Fields("CREDIT")) strCREDIT1 = Nz(.Fields("CREDIT1")) strCREDIT2 = Nz(.Fields("CREDIT2")) strCREDIT3 = Nz(.Fields("CREDIT3")) strCREDIT4 = Nz(.Fields("CREDIT4")) strCREDIT5 = Nz(.Fields("CREDIT5")) strCREDIT6 = Nz(.Fields("CREDIT6")) strMILGUIDE = Nz(.Fields("MILGUIDE")) strMILGUIDEWEB = Nz(.Fields("MILGUIDEWEB")) strREVISION = Nz(.Fields("REVISION")) .Close End With strDAY = Format(strDAY, "d") strMONTH = Format(strMONTH, "MMMM") strYEAR = Format(strYEAR, "yyyy") If strDAY = "1" Or strDAY = "21" Or strDAY = "31" Then strDAYext = "st" ElseIf strDAY = "2" Or strDAY = "22" Then strDAYext = "nd" ElseIf strDAY = "3" Or strDAY = "23" Then strDAYext = "rd" Else strDAYext = "th" End If strName = UCase(strName) strCOURSE = UCase(strCOURSE) strCOURSE1 = UCase(strCOURSE1) strCOURSE2 = UCase(strCOURSE2) On Error Resume Next Set objWord = GetObject(, "Word.application") If err = 429 Then Set objWord = New Word.Application End If On Error GoTo 0 With objWord .Visible = True If Me.optCO Then 'Set doc = .Documents.Add("X:\Company dbase\Blank Forms\DIPLOMAsigned.dot") Else Set doc = .Documents.Add("X:\Company dbase\Blank Forms\DIPLOMA.dot") End If ' Fill the above Word Template with the below bookmarks information With doc.Bookmarks .Item("DAY").Range.Text = strDAY .Item("DAYext").Range.Text = strDAYext .Item("CLASSNO").Range.Text = strCLASSNO .Item("MONTH").Range.Text = strMONTH .Item("NAME").Range.Text = strName .Item("COURSE").Range.Text = strCOURSE .Item("YEAR").Range.Text = strYEAR .Item("ACE").Range.Text = strACE .Item("CID").Range.Text = strCID .Item("VERSION").Range.Text = strVERSION .Item("COURSE1").Range.Text = strCOURSE1 .Item("COURSE2").Range.Text = strCOURSE2 .Item("LENGTH").Range.Text = strLENGTH .Item("EXHIBIT").Range.Text = strEXHIBIT .Item("LEARNING").Range.Text = strLEARNING .Item("INST").Range.Text = strINST .Item("CRED").Range.Text = strCRED .Item("CREDIT").Range.Text = strCREDIT .Item("CREDIT1").Range.Text = strCREDIT1 .Item("CREDIT2").Range.Text = strCREDIT2 .Item("CREDIT3").Range.Text = strCREDIT3 .Item("CREDIT4").Range.Text = strCREDIT4 .Item("CREDIT5").Range.Text = strCREDIT5 .Item("CREDIT6").Range.Text = strCREDIT6 .Item("MILGUIDE").Range.Text = strMILGUIDE .Item("MILGUIDEWEB").Range.Text = strMILGUIDEWEB .Item("REVISION").Range.Text = strREVISION .Item("SIGN").Range.Text = strSIGN End With End With objWord.Activate End If mysetgrad.MoveNext If mysetgrad.EOF Then Exit Do End If iSSN = mysetgrad![SSN] LoopEnd If
    page tag? Access V1.X UtfBTWFydGlu
• Task Bar
  • Suddenly my task bar appear vertically on the right of my desktop. How can i change it ?
    page tag? Access V1.X UtfBUGllcnJl
• Haha
  • 
    page tag? Access V1.X tom
• What
  • What!
    page tag? Access V1.X tom
• Action Queries
  • One of the user options within Access is to confirm action queries. I know a user can untick this option so that it doesn't alert them to all the queries that run when my database opens, but I wonder if anyone can suggest a way to set it programmatically to always untick the box. The problem is if the profile doesn't load correctly, they get faced with a load of confirmations including 'are you sure you want to delete... rows' which scares them somewhat!Thanks in anticipationDave
    page tag? Access V1.X UtfBRGFZSBSZWFyZGu
• Monthly Reports - Macro Count
  • Hello community ^_^ I'm in the need of some help!I got 2 questions that hopefully you guys can help me find the answerFirst,The function of the database is to store the information of printer cartridges. We normally do storage count every month, so I need a report to print out how many cartridges were used based on the count in the storage room and the new count. So basiclly OldCount-NewCount.NewCount: will be inputted by user.Total Used: NewCount-OldCountOldCount: after the calculation, it will then get the value from NewCountHow can I be able to do that in a form?Second,I would like to know how can I create a report that will ask me an StartDate and an EndDate and depending on the info inserted it will display the records. This is to display the TOTAL USED cartridges used per month.Database Structure:- Table (Storage) the table contains these fields: Manufacturer, Model, Category (all referring to the cartridges) a field for Storage (I use this for oldcount) and the Count field (we can use this as newcount), Total Used (empty, but on the query I set it as Storage-Count) StartDate and EndDate fields empty.- Form (Storage) is based on the Table.- Query (Storage) displays all fields from the table.I really appreciate any help, and I'm willing to mail a copy of the database if anybody wants to take a deeper look into it.~Manny
    page tag? Access V1.X UtfBTGjbJhbnM
• Help W Conditional Formatting In Vba
  • I am trying to apply conditional formatting. i have to use codesincei have 10 different conditions. basically, i want to change thecolorof the font color and backgroud color of a text box (txtRoleName)based on the value.I tried writing an If statement on the details part of the form, butican't seem to get it to work. I cant find a value that works. Itried using *ctrl *space after i type in my texbox anme, but cantfindanything that seems like it would work from the drop down thatappears. Here is the logic i would like to follow:If txtRoleName.Value = "Student" ThentxtRoleName.FontColor = vbRedtxtRoleName.ForeColor = vbGreenElseIF txtRoleName.Value = "Faculty" ThentxtRoleName.FontColor = vbGreentxtRoleName.ForeColor = vbRed
    page tag? Access V1.X Gaby Sandoval
• Bluetooth Problems..... Please Help!!
  • hi, need help with my bluetooth (bt). i have the DIgitus tiny usb adapter (dongle) to connect to my Sony ericsson w190i to my desktop there are NO instructions with the dongle.plug it in it finds all the drivers and loads, there is a icon in the "network conections' with a red cross over the icon and reads disconected,firewalled i cant get the default window bt icon to come up in my control pannel i have the same XP at work i plug it in at work it loads the drivers and and the bt icon pops up in the control panel/network page but cant get it to do it at home i have tryed un/re install the driver and the sony prog, it just not bringing up the bt on my hyome pc, it just reloads the drivers and then stalls best answer would be apriciatedthanks in advance -- its not me, its my ego
    page tag? Access V1.X UtfBQWxsYWFZA
• System Files Need Updating????
  • Hi, I have an Access program that I package with Access runtime using office developer 2000. I sell this program to raise money for St. Judes Hospital and have very few install problems. I currently have a user that when he runs the setup program he gets an error stating that some system files need to be updated. He then gets an option to update the files and if he clicks yes something happens and then he get a message that setup needs to be run again. When he runs setup again he gets the same system file needs update message. He is running XP Pro.Any help would be appreciated.Thanks,Phil-- Phil
    page tag? Access V1.X UtfBUGhpbA
• Opencurrentdatabase In Second Instance Of Access Does Not Throw Error If It Failes
  • Access 2007I have code that creates a second instance of Access and uses it to open another database as itsCurrentDB: Set mappAccess = New Access.Application mappAccess.OpenCurrentDatabase strPathDBName, False, strPasswordIf the OpenCurrenDatabase method fails (i.e. the strMDBPath is locked because it is already openedin exclusive mode) it does not throw an error. It just doesn't open the database.If I open Access and manually try to open a database that is locked Access throws an error saying itcan't open it.Why doesn't the OpenCurrentDatabase method throw an error? Is this by design?
    page tag? Access V1.X Stewart Berman
• Enlarge Toolbar Size/Font
  • Is there a way in Access 2000 to enlarge toolbar size or font without using the "Large Icon" option (which changes the menu size in all office programs)? Thanks
    page tag? Access V1.X UtfBUFBDTw
• Updating/Changing Mde Databases
  • I am using an FTP process for transferring data. In the past I have done this several times using mdb databases. The user would download a file, the file would open and perform certain functions, close and open a different database.Using this system I was able to get new forms, tables, queries, etc. to the users. In the Autoexec macro of the file they downloaded and opened. I would use the copy object method to export new objects to the other databases. I am now using a similar FTP methodology but with mde files. Is there a way to export to and/or replace objects in an mde file, or do I have to replace the entire file? This is a very complex program. The FE is 450 mb. Is replacing the entire FE the only way to make changes in the mde files?Thank you for your help.
    page tag? Access V1.X UtfBQXJdXJv
• Access 2007 Interface Controls
  • I'm having a great deal of trouble trying to set the interface tolimit what users can do and see. I've come across one web site whichdetailed code for creating/setting database properties, but even thencertain interface properties are over ridden by user's settings.My 2 main issues are hiding the navigation window, and making theprint command available (from the ribbon or menu) while disabling (orhiding) most other commands.I'll continue to search forums and the web, but if anyone wants toshare their approach to the 07 interface, I would like to hear aboutit.THANKS!David G.
    page tag? Access V1.X David G
• Append Query Question Regarding Nulling Data
  • HiI have an append query that is working fine. But for some of the fields, if they contain certain values, I want them to be nulled out when they are appended. For instance if the status is anything other than 'Confirmed', I want it to be nulled when appended.Does anyone know how to do this?thanks-- Nancy
    page tag? Access V1.X UtfBTnVycUgTmFuYk
• Msg Box With Conditions And Display A Value From Form On Message
  • Hi,I have a Control button on a form that opens another form, I want to display a message pop up on the new form if a calculated value on that form is greater than 0, then the user can choose to close the new form or ignore the warning.If it's less than Zero, then i would disply a different pop up message.I have 3 problems,, and if anyone can help with any one of them,, i would be ever so greatful!1. Where do i put the VB for the popup message,, so I can see the form open and make a decision on whether to close it.When i put it on the 2nd form property sheet,,,On current - It displays after i hit the control-button, while I am still on the first form so I can't see the new form openOn Focus - It displays while i am still on the first form so i can't see the new formOn Click - Nothing happens, I don't get a messageI ended up putting it on the detail section of the new form and now whenever I click on that, i get the message,, i only want it once after the form opens.ANy suggestions?2. I only want the pop up message to display if the value of a calculated field is greater than zero and I want to display the value in the message.The field is called Diff TB on the form and is calculated as Sum([Prime Rate]*[Prime Spots]+[Rot Rate]*[Rot Spots]+[Other Rate]*[Other Spots])I don't know VB and when i tried to use the calc as is,, i get a syntax error3. How do i code it so if it's greater than zero, i display a different message?Here's the code without the calc, which also doesn't workPrivate Sub Detail_Click()If [Diff TB] > 0 ThenDim Msg, Style, Title, Help, Ctxt, Response, MyStringMsg = "Weekly Budget is Greater Than Total Perspective Buys, Do you want to Add More Stations? Weekly Budget = $$$$$$, Diff = $$$$$$$"Style = vbYesNo + vbDefaultButton2Title = "MsgBox Demonstration"Help = "DEMO.HLP"Ctxt = 1000End IfResponse = MsgBox(Msg, Style, Title, Help, Ctxt)If Response = vbYes Then ' User chose Yes. MyString = "Yes" DoCmd.RunCommand acCmdSaveRecord DoCmd.close acForm, "Weekly Buy Table Form", acSaveYes Else ' User chose No. MyString = "No" ' Do NothingEnd IfEnd Sub-- Nancy
    page tag? Access V1.X UtfBTnVycUgTmFuYk
• Adding To Dropdown List
  • I am using Access 2003It has been quite some time since I have made changes to a database andforgot how to enter new selections.I have a database for restaurants. One of my dropdown boxes allows me toselect Type Food, such as American, Italian, etc.I want to add other ethnic food types and forgot how to do this.Could someone please give me instructions to add additional food types to mydropdown list.Please make it simple as it is difficult for me to follow very technicalexplanations.-- Thank you in advance for your support and suggestions,HankL
    page tag? Access V1.X HankL
• Copy Or Duplicate Record Woes
  • Hi EverybodyAccess 2007I have a form based on a query that does NOTinclude the primary key autonumberAnd I am trying to use the "Duplicate" commandYet I get the error that this new record has created"duplicate Values in the Index, Primary Key, or Relationship"Is there any other way to copy a record?Thanks
    page tag? Access V1.X bobdydd
• Hey
  • check
    page tag? Access V1.X Adam M Champlin
• Confimation
  • again tis is to confirm connection
    page tag? Access V1.X Roy Eaton
• Sort In Query
  • I have problem to sort below field in my query.([fstrlsedt]-date fieldRelMthYr: Format([fstrlsedt],"mmm-yyyy")I expect to get Jan-2009,Feb-2009 & so on...but turned out to be Apr-2009,Aug-2009,Jul-2009....Thanks
    page tag? Access V1.X UtfBenlcw
• Time Sheet Design Help
  • I am trying to design a database timesheet/clock for a department that needs to track daily time in, lunch out, lunch in, daily time out.I don't want the associates to be able to manipulate the time in any way and started with using the date/time stamp from the system but with that field, I'm not finding that I'm able to calculate the hours worked for an employee as I'm creating 4 records for that day and I'd like to somehow create one record for the employee for a given day.They basically need to be able to go and 'punch in' and 'out' when the time comes and have that time 'stamped' from the system and not manually put it in themselves.Is there a way to set this up so that the employee can enter their time in/out or have 4 entries for one day or even just two if no lunch, and have that time 'stamped', like a "Now()" so that they not enter the time (honesty issues) AND be able to calculate the hours worked in a report? I don't want any times to change or update upon entering the record again.Thank you so much!Harriet White
    page tag? Access V1.X UtfBSGFycmlldA
• Alessio
  • 
    page tag? Access V1.X Alessio
• Multiple "And" In Where Clause
  • I have a table with 2+9 fields.I want to display rows for if [field3] and [field4] and [field5] and [field6] and [field7] and [field8] is not blank.I am trying this using Where Clause but it's not working.I triedWhere (field3 is not null) and (field4 is not null) and (field5 is not null) and so and so...Please help.Thanks
    page tag? Access V1.X UtfBaF
• Table Information Not Matching In Form Design
  • I've created a table with information from an excel file I imported. I've designed a form to enter information if needed. When i was looking through the information in the form i designed, the information was scrambled. I looked at the table and the information is correct. What causes this to happen?mePenny
    page tag? Access V1.X UtfBbWVQZWueQ
• Remove Add-In
  • I have Office 2007 running on a laptop with Windows Vista Home Premiun. I also have Adobe Acrobat 8 Standard. My add-in for Acrobat has stopped working but I can't remove it. Every time I try all I get is the following message:This add-in is installed for all users o n this computer, and can only be connected or disconnected by an administrator.I am the only person who uses this laptop and my user account is set as administrator. Can someone please tell me how to get this freaking crap to work right so that I can actually use my add-in.
    page tag? Access V1.X UtfBRGVlaiBIZXJuYWkZXo
• Link To Xls Or Import Dbf
  • I posted this in Import/ Export ..no replies yet. Looking to see if someone reading here might know the solution...A snippet (see below) of an Excel file that I tried Access linking to Excel...the Color "3R3" below links in Excel as #Num! (a dealbreaker).If I save as a DBaseIV, any Color NOT readable as a number arrives as a Blank.Also, saving as a DBF changes all the "GoPK" below to a Date..IE 9/10/09. I can deal w/ that in the VBA code I use working w/ the DBF. I had hoped to either bring in a GoPk (IE...9/10/09 6:49:09 AM) as a Date (w/time), or use as a PK (as a text)..which would be unique combined w/ Booth as a multi-key PK. Is there a known "negative" using a longer text (IE...9/10/09 6:49:09 AM) as part of a PK?I could also deal w/ this data w/o using a PK.The ISSUE now...getting all Color values in the DBF when they appear as a number (IE..202), or a text (IE...3R3). TIA - BobGoPk Booth Acolor9/10/09 6:49:09 AM C 2029/10/09 6:53:33 AM D 2029/10/09 7:55:44 AM D 3R39/10/09 8:12:30 AM C 202
    page tag? Access V1.X UtfBQmiIEJhcmlcw
• 123
  • hi!
    page tag? Access V1.X yu
• Wangganghaha
  • 
    page tag? Access V1.X wangdan
• Xiexie
  • 
    page tag? Access V1.X wang hong
• Happyningning
  • ningning
    page tag? Access V1.X hsppyningning
• 11111
  • 22222
    page tag? Access V1.X princess
• Msnew
  • 
    page tag? Access V1.X miss zhang
• Populating Main Form After Changing Selection
  • On my main form I have fields displaying ticket #, group name ticket is assigned to and phone number for respect group. If I don’t have a phone number I am not displaying field for phone number.On same form I also have a subform on which I am displaying only open tickets.After clicking on ticket in a subform ticket is populated to fields in a main form, however in addition I would like to populate fields for a phone number or make them invisible when there is no phone number.Here is a code I am using:Private Sub Form_DblClick(Cancel As Integer)Dim lngTicket As LonglngTicket = Me.[Ticket #]Me.Parent.RequeryMe.Parent.Recordset.FindFirst "[Ticket #]=" & lngTicketForms![Remedy Tickets]![Status].SetFocusEnd SubI have a combo box I called Assignto and after selecting specific group phone numbers are provided for each group. I noticed that when I select specific ticket from subform main form is populated, but when I changed assigned group, phone number doesn’t change and it is a previous selection phone number. How I can update phone numbers when I want to change group name? Thanks
    page tag? Access V1.X UtfBRJlZw
• Upgrading 95 Databases & Using Runtime
  • I need to update some Access 95 databases to overcome the 1GB ramlimit of Access 95.I have Access 2000.1. What are common hurdles to expect when upgrading 95 databases to2000?2. Is the Access 2000 Runtime available anywhere?3. WIll the Access 2007 Runtime read Access 2000 files?Thanks!Rob
    page tag? Access V1.X rob
• Report Paging Problem
  • Access 2007 running on Windows XP. Report is a multipage letterformat and Access is not handling paging correctly when a text field,which can span multiple pages, is followed by a page break and finalpage. The letter report is called from a form where the text isentered. Here's what happens: If text can fit on a single page thereis no problem. If text grows and extends to the next page, a blankpage is displayed after the text and then the final page isdisplayed. Access gets confused calculating the number of pagestoo. It includes the blank page in the current page count but thetotal page count doesn't include the blank. For example if 5 pagesdisplay, the footer will display page 4 of 4 on the blank page andpage 5 of 4 on final page! note: When the page break is removed,there is no problem.Also I tried getting the text from a database column rather than fromthe form but still the same problem.
    page tag? Access V1.X bontemps
• Appending To A Combobox
  • I was wondering if I can have a ComboBox populated by a query but always have the words of 'Select A Name' showing when the form loads. That way, I could check to see if the value is 'Select A Name' to populate a message stating 'please select a valid name.Thanks for your assistance.
    page tag? Access V1.X UtfBQnVuak
• Vc Recebeu Meu Msn
  • 
    page tag? Access V1.X ezequiel
• Counting Specific Characters Within A Field
  • OS: Windows XPApp: Access XPI have a field with over 100 characters of data. I want to count the number of Tildes (~) found within the field and their position.I want to extract text strings positioned between each occurrence of each Tilde.Any help would be appreciated.Kind RegardsMike
    page tag? Access V1.X UtfBTWlrZSBGYXVsalcg
• Leading Zeros
  • I use Access as a database for my library. One of the columns is for the ISBN number. When these begin with a zero Access removes it/them. So far I have got around this problem by using 0. before entering the number.In Excel this can be got around by formatting the column as text but this option does not seem to be present in Access.Has anyone used a better way of combating this issue in Access?-- Alan
    page tag? Access V1.X Alan
• Modifying/Appending Records Between Subforms
  • I need some guidance and perhaps some inspiration. I'm working on a database containing a main form with 2 subforms side by side. Subform1 is a continuous form that has records about the positions a military unit has. Subform2 is a continuous form that starts out wth no records.Basic Subform1 record fields: UIC, Para, Line, Auth Str, Req StrCombo PK on UIC, Para, LineWhat I'm trying to do is to 'maybe' click a command button on a record in Subform 1 and have the data of that record append to Subform2. While doing this it should subtract 1 from Auth Str and Req Str, and change the appended record's UIC to the contents of an unbound text field on Subform2. If Auth Str and Req Str would end up being "0", then it should append then delete that record from Subform1. When the append to Subform2 takes place, it should either add that record, if it doesn't exist, or add 1 to the Auth Str and Req Str.In case the user made a mistake, Subform 2 will have a similar command button to carry out the same action.I was hoping someone could point me in the right direction.
    page tag? Access V1.X UtfBRGFaWQgTXVsaGsbGFuZA
• Phantom Network Drives Created?
  • Hi, we have a simple db created in Access 2003 that is installed on PCs running XP Pro and now Office 2007.At times when it's installed from always the same mapped drive letter (the db resides on a network drive) on the clientPCs several phantom drive letters appear on the target PCs. How can I stop this from happening?Let me know if I haven't adequately described the problem.Sam
    page tag? Access V1.X Sam
• Hilsen Fra Slevik
  • Hallo ReidunTusen takk for hyggelig hilsen. Det var godt å lese at alt står bra til hos dere.Jeg skjønte ikke helt det med Tom og venninde, men det kan vi jo snakke om en annen gang.Jeg har nå gått over til en sprøyte som har 50 % større virkning enn den jeg tok tidligere.Kreft er jo ikke så lett å få tatt knekken på, men bare den kunne vokse litt saktere er jeg fornøyd.Vi hadde besøk av Ulf sist helg og det var hyggelig. Han er flink til å stikke innom når han først er i Sverige.Heidi sliter fortsatt med sin ME men hun er nå adskillig bedre, synes jeg. Hun har nylig kjøpt seg bolig på Gressvik som heldigvis ikke er mere enn 6-7 år gammel så der behøver ikke Sverre å gjøre så mye ennå.Nytt kjøkken og dobbelt så stort er det blitt i huset til Yvonne. Veggen mellom kjøkkenet og "kammerset" er slått ut så det er blitt virkelig bra.Her hjemme holder vi også på med påbygging men det har i det siste stått litt stille på grunn av kjøkkenet hos Yvonne. I morgen skal det startes der igjen, så det blir nok bra.Badet er så godt som ferdig, det mangler bare å liste inn vinduet og sette inn skyvedør som ligger ferdig og venter.Soverummet er også "nesten" ferdig. Der mangler det parkett og tapetsering + noe småtteri. I løpet av uken blir det nok ferdig der også. Sverre har en veldig flink snekker som medhjelper eller som sjef, kan vi heller si.Nå er det nok skryt om hvor flinke vi har vøri(fikk ikke til ae). Hvis jeg får det til kan jeg prøve å sende noen bilder. Ha ha Det der hørtes veldig flott ut.Så vil jeg få ønske dere alt godt fremover og ser frem til å høre fra dere igjen.PS. Jeg har ikke brukt maskinen på minst 2 måneder!Mange hilsener fra Kirsten og fra Sverre naturligvis Ha det !!!
    page tag? Access V1.X isoQKirstenLanggErd
• Current Average Problem
  • I have a database with two tables of relevance to the current problem. One is a record of WORK TITLES, with a PK autonumber field. The second contains a list of STUDENT WORK, which are populated with a studentId, and workId from the first table. I have created a query linking the two tables, and a form in which I can enter marks for each student. What I seem to have trouble doing is getting the form to put the current value of the average for the piece of work into the WORK TITLES table (a field showing in the form). I have played around with the field in which I enter the actual marks, and set the on Change property to DAvg("[Percentage]","ReviewPieceOfWork-Q","[ID]= [ID1] and [Percentage]<>0") where [ID] is the autonumber value, and ID1 is the alias of the field on the form (in other words, it calculates the average only for that piece of work). However, it seems to give me the value it was before the last change. If I put a local unbound field onto the form with the same syntax, it returns a different (correct) value. I have even tried changing the value to that of the unbound field but to no avail.Any ideas?
    page tag? Access V1.X UtfBRGFZSBSZWFyZGu
• Dsum
  • see below data:Field Worker Job # Workdate Vacation Time (hours) VH TotVacTak CAGNEY, KEVIN 90180056 9/28/2009 0 12 CAGNEY, KEVIN 90180056 9/29/2009 0 12 CAGNEY, KEVIN 90180056 9/30/2009 0 12 CAGNEY, KEVIN 90180056 10/1/2009 8 12 8 CAGNEY, KEVIN 90180056 10/2/2009 4 12 the 1st column of VH(vacation taken) shows the acutal date the vacation taken. the second column is the DSUM- formula - text box (passed back in based off the the dsum by man name and date within 2009) the total is correct - BUT DO NOT LIKE that the dates prior to it taken(9/28-9/30/09) show up as having used 12 hours of vacaction - anyway to add code in to it show a Running Actual total - Thanks sooo much for helping! Barb "Frank H" wrote:
    page tag? Access V1.X UtfBYmFicw
• Comparing Two Tables
  • Hi I need to compare two tables that have some overlapping data (from different sources). ExampleTbl 1 Tbl 2Date, Color, Count Date, Color, Count, ShadeI'm comparing the color feilds and calculating the difference in Date and Count returned by the two different sources. The problem is some records in Tbl 1 won't be in Tbl 2 and vice versa while some records will be in both. How do I write a query to get a single data set that lists the compared results without picking up duplicates or omitting data not in both tables. I've tried Unions but must be missing something. Thanks for any help.
    page tag? Access V1.X UtfBamNsYWlibI
• Need Help With Form
  • On my form, I want to show transmission information if the account has a transmission. I am new at this. The transmission is a Yes / No field on the table; the transmission details are in a separate table. I only want the information to appear if the account has a transmission associated with it. I tried a subform, but it appears whether the transmission is checked or not. Can someone help?Thanks.
    page tag? Access V1.X UtfBbGFkeWxsYnVn
• Losing Table Index
  • I have a secondary table that contain various fields that hold the indexes of other table records. This secondary table is independent of the primary table that contains the records.Question:1) When I repair or compact the DB, do table indexes change?2) Is there anyway to save the indexes of the primary tables in a secondary table field and maintain the link to the primary table such that if the primary table record index changes (e.g. repair or compaction) the secondary table fields (which hold the index values) also change?ThanksDavid
    page tag? Access V1.X David
• Protect Data Once Entered Into Field
  • I have a database with loan numbers and issues/incidents associated with the loans. Is there a way to lock the information, once it's been entered? I've already had a couple of loan numbers deleted by other users in my department. I'd like to maybe create a pop up that questions whether the user really wants to do what they are trying, which would be any time someone tries to edit information already entered in the field. Suggestions?
    page tag? Access V1.X UtfBUJlYtlcg
• Sometimes Gotfocus Event Doesnt Occur On Subform...Strange
  • I have a mainform and a subform (named Lookup_results). The subform is bound to a query. There is a lookup button on the mainform with code DoCmd.Requery "Lookup_results" followed by Me.Lookup_Results.SetFocus to populate the text boxes on the subform. I want to have a msgbox appear when the query returns no data. To do this I put this code in the GotFocus event of the subform: If Me.RecordsetClone.RecordCount = 0 Then MsgBox.... I have not set focus to any of the controls on the subform. So far everything works correctly....until I added another text box to the subform. Now the GotFocus event on the subform doesn't occur when there's no data. If I remove the newly added text box then everything works correctly again. Why not? I need to add the textbox to the subform.Thanks in advance, Joe M.
    page tag? Access V1.X UtfBSmlIEu
• Hello
  • ðÒÉ×ÅÔ ×ÓÅÍ!!!!
    page tag? Access V1.X giust
• Vous Inquiete Ses Pas Lune Que Pete
  • 
    page tag? Access V1.X fabien carpignano
• Linking A Table In Access With 365 Data Fields
  • I am trying to link an ODBC database table that contains 365 data fields and only the first 255 fields appear after the table is linked in Access. Does anyone know why the last 101 fields are not linking into Access? Is there anyway to get these fields to link in?Thanks,Mike
    page tag? Access V1.X UtfBbWJsYWtl
• How Do I Change Program From Read Only
  • I want to open my databases in a normal format to manipulate information can anyone assist me with opening program in a normal format?
    page tag? Access V1.X UtfBVldN
• Disable Filed Condition
  • Hi, I want to disable the field depens on other field input as below:data 1 data2A Enable the field for inputB Enable the field for inputC Disable the file for inputI try below only work for condition either one in data1Me.data2.Enabled = (Me.status = "A")Below is errorMe.data2.Enabled = (Me.status = "A" or "B")RegardsTom
    page tag? Access V1.X UtfBdGt
• Word 2007 Is Locked And No Application Working .
  • i got HP laptop with 60 days trial version of office 2007 built in it.Its been 18 days and my Ms word has locked and i am not able to type any thing any thing into it.pls help.vikas2joshi@yahoo.co.inthanks
    page tag? Access V1.X UtfBbGjaVkIHZpaFz
• Help With Date Difference Expression
  • Good morning,Based on the following:Lost Days = DateDiff("d",Nz([MyLostDaysBeginDate]),Nz([MyLostDaysEndDate]))Restricted Days = DateDiff("d",Nz([MyRestrictedDaysBeginDate]),Nz([MyRestrictedDaysEndDate]))I need an expression that will subtract the Lost Days from the Restricted Days, when the Lost Days date range is the same (or between) as the Restricted Days date range. This will yield total Restricted Days.Example:Restricted Days were incurred from 02/01/09 to 03/01/09 and Lost Days were incurred from 01/01/09 to 02/15/09. The overlap occurs from 02/01/09 to 02/15/09.How can arrive at the Total Restricted Days?Thanks in advance for your help,Rene
    page tag? Access V1.X UtfBUmVuZQ
• Order Entry
  • I have two tables related as one to many. The first table is"tblOrders" the many side "tblProducts". I would like the user tochoose from one to many products and after choosing, click a buttonthat assigns a unique order number in the tblOrders table. Should theuser at any time decide to cancel the whole thing, then that uniqueorder number would not be used and no record would be created. I wantto avoid autonumber since the order number will reset each month (eg S(yr)-(month)-(No)).What is the best way to accomplish this?Dave
    page tag? Access V1.X Dave
• Combo Box Requering
  • This should be very simple but I cannot seem to get it to work. I have a form that has 2 combo boxes. The first one is the supervisor and the second is the specialist. I want the specialists to change when the supervisor is changed. I have read and re-read the postings that say to do a Me.Requery in the After Update event of the driving combo box (In this case - Supervisor). The supervisor combo box is driven by a query and the specialist combo box is driven by code on the Row Source. Since I am using both combo box values to feed other queries, I have moved each to textboxes.Supervisor is ComboBox 17 and the value goes to textbox 37Specialist is ComboBox and the value goes to textbox 52Everything works fine on the first supervisor chosen and I can change the specialist all day long with no problem. But when I chose a different supervisor, the specialist values do not update. Why? Ideas?
    page tag? Access V1.X UtfBQnVuak
• Concatenation On Two Fields
  • I have two text fields that I want to automatically concatenate together to create a third text field. For example, text field 1 is a list of values such as T1039, S0297, S0416, S2274. Text field 2 is a user input value with an R concatenated on to the front of it. So, user might enter 001, but the value needs to be stored as R001. But, then I need a Text Field 3 to store the two inputs as TextField1&TextField2, i.e. T1039R014?
    page tag? Access V1.X UtfBSVubnlE
• Create A Specific List
  • Access 2003Is there a way that I can select specific records from a database to print out specific columns for those records?As an example, I have a database of restaurants. I want to select certain restaurants in that database to print out on a sheet of paper for a friend.-- Thank you in advance for your support and suggestions,HankL
    page tag? Access V1.X HankL
• Sobre Los Tres Millones De Pesos
  • 
    page tag? Access V1.X bautista
• Headers And Footers
  • I am creating a Monthly Reporting Databook. I have tweaked my layout to resemble a designed report and have made all my margins '0' to optimize the page space and layout.My Footers now do not line up with the edge of the margins (left and right). Is there anyway to move the footer margins so they line up with the edge of the page.I KNOW IT IS NOT A LAYOUT PACKAGE!
    page tag? Access V1.X UtfBYFkZWJlMTE
• Requery Combo Boxes
  • On my form I have two combo boxes, Supervisor and Specialist. Obviously, the Specialist is driven by the Supervisor that is chosen. You have many Specialists to one supervisor. These both are populated by queries. The first time a selection is done, everything populates correctly. When a different supervisor is chosen, it does not requery for the specialists associated with the new supervisor selection. I have put in requery statements on the Form - On Current event and tried coding them in the combobox after update event. I cannot get them to fire again. I tried to go the website that Mr. Sheridan suggested on another post but it is blocked by our system. Any help will be greatly appreciated.
    page tag? Access V1.X UtfBQnVuak
• Charts From Select Query - Fields Not Recognized
  • When using a select query as the source for a chart I am getting an error that the date ranges are not recognized by "jet". I haven't a clue as to what that means. The criteria for the dates are sourced from two unbound text fields on a form that default to the first and last day of the current month respectivel. Each is formatted as "mm/dd"yy". The criteria in the query for the field "main!date" is "between forms!formname!sdate and forms!formname!edate". "sdate" and "edate" are the names of the unbound text fields. To get around this I changed the select query to a mktable query and use the table as the source for the chart. The table which is deleted and refreshed when the database is open is causing more annoynaces. I have no desire whatsoever to maintain this method of creating the charts. Any assistance in making the charts to function as intended with a select query is much appreciated. If I must however use the mktable solution then I'd appreciate some help forcing the macro to continue on if the table it's looking to delete doesn't exist. Thanks,Shane
    page tag? Access V1.X UtfBchhbmU
• Upgrade To 2007
  • Is it possible to upgrade directly from Access 1997 to Access 2007? I suspect not. What procedure would be involved in transferring my data from 1997 to Microsoft Office 2007 which has Access 2007?-- betty
    page tag? Access V1.X UtfBYmVdHk
• Resize Form Controls?
  • Can you resize a control (field) on the form and move it independently of the others wherever you want to on the form? I want to place the First and Last Name fields next to each other and the address right below. I also want to group some Medical information on the right side of the form independently. All the controls seem to resize all together. I see the anchoring will move a field up or down, but not with the freedom I'd like to use.
    page tag? Access V1.X UtfBdChLnNtaXRo
• My Ms Access Database Has Become 'Read Only', Help!
  • My MS Access 2003 (part of Office Pro 03) database changed to read only yesterday for no obvious reason. I had loaded an evoluent mouse onto my system and did a system restore to remove the 'mouse manager' programme but that didn't change anything. I have checked the properties & removed 'read only' didn't work, it was a shared doc I removed that but t didn't change anything, I performed a repair in the remove/add programs this morning and it did work briefly, so I took a copy. Then I made it a shared document again, it worked for a while (10 mins) then became a 'read only' file again. There are over 2000 records on this dbase. Any help gratefully received
    page tag? Access V1.X UtfBRWxsaWU
• Date Columns
  • How can I take a table that has a date column and an cost column, and create a report that shows each date in a separate column?Example of Current table:Physician Date Group Edited Lines Expense (Cost)Dr #1 8/31/09 XYZ 450 150.00 9/30/09 XYZ 1423 350.00I would like my report to show each month across the page, as my example below shows:Physician Aug 2009 Sept 2009 Total Expense (adding all months together)Dr #1 450 1423 $500.00Is there anyway to do this, or will I have to create separate tables for each month?Thank you!
    page tag? Access V1.X UtfBUIgQWNjbVudGFudA