Recent content by diggerbob

Thanks a bunch! We will try this tomorrow and hopefully this will solve our problem

I have a form that I am creating where in the first field I input dollar value and the second field I input quantity. A third text box is used as a calculated field based on the first field times the second field. I have multiple sets of these fields on my form and all are invisible except the...

Has anyone used the Christian Steven prgram "MARS" for task scheduling in Access? If so, what are your thoughts on using this and is it worth the investement? BobK

Ian, Thanks, and will be looking forward to hearing from you. BobK

MajP, I understand that I should do that but that data will be imported into the table from an excel sheet. The person using this has to export the data from a database into an Excel worksheet. Then in turn, import it into Access. This will be done on a monthly basis. The names in the access...

Yes, I have got it working, and yes, I could kick myself... for not seeing that! I appreciate everyone's help on this. Bob K

Ian, I will give your ideas a shot when I get to work tomorrow. Thanks Bob K

ck1999, I know you said that you would be out of ideas but I would like you to take a look at the database. I have attached the url where it can be found. If that doesn't work I appreciate your helphttp://mysite.verizon.net/bobkinney/Warehouse.zip

ck1999, No, it still doesn't work, it just doubles the # sign in the error message. I hope by tonight, getting this up and available on line but will let you know. Thanks, Bob K

ck1999, I tried the change but I get compile error messages at the # signs around the word #"And"# PH, Tried your suggestion but doesn't work either.

Bob, this is all of my query and after this I have copied and pasted Visual Basics codes from my date picker form and if this doesn't help, I will send my database up to my web space this evening and you can review it: Query: SELECT [Accrual Table].[Vendor Name], [Accrual Table].[PO No]...

Actually, the error is popping up in Visual Basics

PH, I should have explained my problem more clearly. I cannot find where this query expression is. I have only one table, I did a query from this table, and then did a report from that query. That's all I've done and the date picker should work, but doesn't.

I have used a date picker which uses a calendar on my form for sometime now and have no problem with it. I copied this to a new database that I am starting for someone else at work but every time I try to run it, I get the following error message: Run-Time Error '3075', Syntax error (missing...

I have a report that I use that shows my natural gas usage per day. I also have to show how many days per month it was used. I have a count function set on the report but recently I have came across a problem. There will be days that we shut down and start back up on the same day, maybe even 3...