Recent content by pbrown99

Combinations are great, thanks! I used a inner join from the first code but the second where statement and it all works great! Thank you both!

Got it! Thanks

Okay, now I am lost. The following code works great for opening the report but if I use the SQL or even the query where would the "Buildwhere (me," Or ")" go? The below opens the report with the correct dates. DoCmd.OpenReport "Summary Time and Attendance Register", acViewPreview, ...

is it possible to open a query (Delete) by using the docmd in VBA for a button on a form? like: docmd.openquery "TEST",(now, where would the filter or criteria go?) Thank you for any and all help!

No.... I could make an autonumber but that is about it. Since status 1 & 0 occassionally share either the same start or end date. Percent can not be one since the same percent may be used aswell. Thank you for any and all help!

Two tables need to be linked for query but having problems Table 1 has vendor invoice info like: Name, amount, date, and status (if the vendor is overseas the status is 1, otherwise 0) Table 2 has the cargo charge percentages. Since the percentages change, it has the fields: Status, Start Date...

I have been able to get the form to work with opening a report therefore I know the range feature is working. The problem is when trying to open a query with the "buildwhere".... If I use Docmd.openquery "Delete Holidays",,,buildwhere(me," OR ") the error: "Wrong # of arguments or invalid...

I need to put a DB on the common drive, but only certain persons should have access. Initially , I tried maintaining a table with usernames, etc, to restrict access, but I have been told that I need to use the access security. I have tried to use the print-out for "User-leval security wizard"...

If Me.Captain = True Then Me.Player__.FontBold = True Me.Player__.VBunderline = True Else Me.Player__.FontBold = False Me.Player__.VBunerline = False End If Thank you for any and all help!

From reading the begnning I know that this is something like what I need, but became lost in reading/understanding. I need to run a delete query to delete holiday dates. After a lot of reading and trial and error, I have made a query similar to what it appears SHart00 was looking for by using...

Thank you, after looking more closely at the code, I felt about 3" high asking that.. :) However, here is one I tried solving but kept getting multiple errors. After runing the code for a few days it has become clear that if I continue running it as is, there are going to soo many folders it...

dRahme's post works great, only have one question. When the button runs, a pop up box opens with OK only for the new folder. Is there any way around the pop-up? I have tried seting warnings off via code then via macro, but it does not work. Any ideas? Thank you for any and all help!

I saw this post and perhaps someone can help me. I am looking to underline a field via code (but using Access 97) Tried Me.player.vbunderline = true me.player.fontunderline = true me.player.underline = true But not having any luck... Thank you for any and all help!

I am tring to do the same thing only I am attempting to make a folder by day since there are several reports to print. I tried: mDofReport = Format([Begining Date], "mm-dd-yyyy") DoCmd.OutputTo acOutputReport, "SW Regional", acFormatSNP, "g:\" & mDofReport & "\SW Key Figures " &...