Search results

No problem. Know that if you're dealing with a table of considerable size, deleting the table often will cause the size of the database to balloon and become potentially unstable. Make sure you're performing proper maintenance via Compact/Repair.

Sorry, I misunderstood. vbaInet's solution works.

Assuming you're talking about a query, why not use this: Count: Sum(IIf([status]="Acceptable",1,0))

DoCmd.RunSQL "Delete * From [TableName]"

Glad to help

Does it need to actually change the data in the table to which it's querying or just display in the query a "1" if contains 9, else display "0" Does this mean the query needs to figure out what the last day of the month passed is and pull all records that fall between the first and last day of...

And Trim([OMNI_Status1])>"?9?",1,0) I think what you're trying to do here is trim the leading/trailing spaces from your data. In that case Trim([OMNI_Status1]) gets the job done as it does an LTrim and RTrim. If you adjust your query to read: Sum(IIf([CORRESPONDENT_PURCHASE_DATE] Between...

Check your visible area. If you have your workspace dragged way down or right then it assumes that you're intending on that blank space to be visible. Tighten up your workspace by dragging the visible area in closer or expand your margins to include the larger size. I had the same problem on...

Try This, I've highlighted the changes I made: Private Sub Backup_Button_Click() Dim str As String Dim buf As String Dim MD_Date As Variant Dim fs As Object Dim source As String Const conPATH_FILE_ACCESS_ERROR = 75 On Error GoTo Backup_Button_Backup 'buf = Back Up Folder 'buf is created if it...

"HOLY CRAP!!!". Paperclip

To anyone wondering, this is the solution I came across when I open a form (in this instance informing the user of a process that has started) just before running an import. Sometimes it will open the form but not display the contents until after the import, which makes a "hey we're importing...

Thanks, Bob. That's exactly it -- All I could remember is it started with a "D" :) I was just starting to run down the list in my index to try to find it. G

I seem to remember a method of telling Access to continue accepting/running commands while an import or some other activity is going on in the background. Unfortunately, I dont have the database I used it in anymore and cannot remember the code. Anyone know what I'm talking about and know the...

End. Great Story.

Thanks for the input, Bob. I'll take note for the next example I post : )

HK1 kind of beat me to the punch of uploading something similar, but this is something i've been working on for a week or so now when I have free time at work. In a nutshell, I was developing a solution to having user-level security without using the one integrated within Access. After some...

I saw one...

SQL looks good... My guess is you've got a problem with your Employee names on the Personnel table. If you'd like to upload the database I can take a closer look. I'm no expert like a lot of the guys around here, but there seems to be something basic missing somewhere.

Could you post the SQL statement for your query? To do this, open your query in design view, then change it to SQL View.

How are your two tables related to each other? Do you have an employee# (or some other identifying field) that links the 'laborused' and 'personnel' tables? A little more information on your database would greatly help diagnose the problem. Guy