Search results for query: *

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...

chazgaz, I believe I put this formula in a control on my report rather than in the query but I will double check on Monday when I return to work and let you know for sure. Thanks for your help also Leslie. Bob

Is there any way that the amount of buttons on each page of the switchboard wizard can be increased without having to design a custom switchboard? Access only allows you to have 8 buttons per page. I'd appreciate some help. Thanks, Bob

Thanks for all the help Skip and PH. The solution works great! I am slightly more than a beginner and am learning on my own. Hopefully when the company hires me on as a permanent employee, I want to take some Access Classes. I like working in it but it can be a little mind boggling. Again...

Skip, No, my run times will never go over 24 hours in any given row. Only when I want to see the total for the month. Your help is much appreciated. I will try this tomorrow to see how it works. Thanks, Bob

Skip, I forgot to send you the formulas in my controls on my report. The one control was =Sum([System1RunTime]), the other one was this for an average of =Avg([System1StopTime]-[System1StartTime]). They do not calculate correctly. thanks bob