Search results

When you tab from page to page, it puts the focus at field tab 0. The field it was defaulting to was 2 fields over. I changed the tab value from 0 to 26 and now it works correctly.

I have a form that has 2 tabs. If you DO NOT enter in any information, the form should not be dirty. But if you hit the 2nd tab and view the information and then hit the 1st tab, the form shows as being dirty. Any clues as to why it thinks I entered in information even though I did not?

I have a query with a field called Month which holds the name of the month and year. Example: Oct2002 How can I get a count of that field for a item that you select on the form?

I have a table that has the following fields that I am interested in: Table: OutageList Field2: Product Name Field6: Total Down Time Field7: Month What I want the graph to do is when you are viewing a saved record with the field "productview" selected it will graph out the item in...

Does any know how to do a compact and repair database within VBA Code?

Here is the code: DoCmd.RunSQL "Delete FROM [YourTableName]"

I have a table called servers that I import data into. After you exit the database, I would like to delete all the records from the servers table. Any ideas on how to do this? Code examples would be great!! Thanks in advance...

And =DLookUp("[Servers]","ServerLst","[ID] = 19") Will give me the name of item 19!!

=DCount("[Servers]","ServerLst") This gives me the correct number of items in ther server field from the serverlst table. Which is 19. Anyone know how the get the name of each item? Say ID 1 = server1 ID 2 = server2 ...... ID 19 =server19 psudo: name$ =...

I have a table called 'serverlst' that has 19 items in it. What I am trying to do is have a command button on my forms page that will allow me to select 'ALL' the items in my serverlst table. I am trying to do something like this: for x = 1 to #items in serverlst table open for write item x...

Each Table pertains the the server information. Should I just do 1 HUGE table that contains all my servers?

Yes - The subform is located at the bottom of the form.

I have about 15 different tables that represent my servers. I have a dropdown on my form that selects the server that I need information on. How can I get the dropdown to select the correct table and display it? When I create the subform, I can hardcode the record source to be either of the 15...

The error message I was getting needed a field called F1. The wizard creates fields called field1, field2, etc. I renamed my fieldsx to fx and it worked like a charm. If I had real field names like field1, field2, field3 etc How can I get the import to go to the correct fields? Do I need to...

I found away to keep it all within Access. I have it open the file for input #1 and open for output #2. I then read the line in and do a linex=linex+1 I then look to see if x>7 (i only need the first 6 lines deleted) then if it is, start print #2, mystring Then I have it close delete the old...

I have a text file that I import into Access but need to remove the 1st 6 lines of data. Does anyone have any VB code that will allow me to do this?

I have searched the forum over and cannot figure this one out. I am trying to import "c:\test\server.txt" Here is the cmd: DoCmd.TransferText acImportDelim, , "tablename", "c:\test\server.txt", False When I run it, it tells me field F1 does not exist in the destination table. Here is what the...

How can I check to see if a text file is still open and being written too?

I can get the MsgBox to pop up and allow you to hit 'ok'. What I need is the box to pop up as information only. I do not want to have to press the 'ok' button to continue. What I am trying to do is the following: I am writing information to a file and want a pop up saying 'please wait' but...

I have a form that was designed in 1024x768 and I just found out that most of the users that will access it will be using 800x600. When the mdb is launched, it opens the form in full screen mode. The end user cannot change this. How can I tell it to position correctly for 800x600? When I made...