Search results

I've done similar. I make the row source for Combo2 based on saved Query2 based with =Form![FormName].[Combo1] limiter in it and Query3 =Form![FormName].[Combo2] and on down the line.

I also see where the user could reopen the database and try again. I'd put a yes/no field in the employee table to lock them out.

I will revisit OutputTo and give that a go. In the mean time I went with opening a form in dialogue mode on a 2 second delay which allows the Save as dialogue box to come up first. Edit: Yeah, I just went with outputto and I'm in business. This also removes the user screwing things up by...

I know that. But IIRC when using it it didn't remember where you saved your file to the last time. CutePDF does. Which makes it difficult to attach the file through automation. At least when I initially tried it that seemed to be the case. Maybe it was something else, but I knew there was a...

I have a Subroutine that is using CutePDF writer to create a PDF from a report, then attach it to a new message in outlook. The problem is the code runs too fast and it's looking for the file to attach before the file is created. I'm getting Run-time error '-2147024894 (80070002)': Cannot...

See I knew I was overlooking something exceedingly simple. Now if you will excuse me, I have to go slam my head against a desk until it's a mushy pulp.

So, I did a search on here and found what *should* work but does not. First - the code Public Function GetCustID() As String strCustWebID = "" If CurrentProject.AllForms("Customer History Form").IsLoaded Then strCustWebID = [Forms]![Customer...

I found a solution that worked. I built a second db and linked the necessary tables (7) and imported the necessary queries (7) and the module that runs it all. Dim objAccess as New Access.Application With objAccess .Visible = False .OpenCurrentDatabase...

You can double click on one of the text headers in the ribbon to get rid of it. I didn't like the nav pane at first, but when looking for all objects that have "customer" or "invent" in them it works real nice, and like it better than the old database window

Could you format the report sheet to a custom size with a near infinite length?

If me.yourstarttimefield BETWEEN trainingstarttime AND trainingstarttime + 1/48 THEN Msgbox("You can't do this.") End If You might need to cycle through the training slot records in a recordset.

If you are still having errors, take out all your error handling and see where it errors. What are the errors?

I don't see how that is relevant to my situation. The HTML output is fine. The files are being written correctly. The code works as it should. What I don't want is Access to continually telling me that it's outputting every file when it cycles through each record in the recordset. Thanks...

It's not a warning, just a dialogue box saying that it's outputting the report. And even after messing with it, it does not seem to work, as I am typing this it keeps taking me back to access.

I've recently "upgraded" to 2007, and here is something that is REALLY ticking me off as it did not do it in the previous version I used. When I get open up my database it checks to the last time I ran a series of reports. If it hasn't been done yet today it runs the report and publishes it to...

Put this in the OnEnter for the date field, or any other event that might be appropriat me.datefieldname = Dmax("[yourdatefield]","[yourtable]")+1

The way to do it is forget about what you used to have on hand. Instead build a query that takes the sum of the received in and the sum of the amount shipped out and subtract them. Why do you need to see a running inventory for every line? My inventory report is similar to the screen shot of...

Just combine the code. It's that simple, really. ;) W/o the error handling: DoCmd.close DoCmd.OpenForm criteria

Yeah, I was running Access 97 with 256MB or Ram with no issues. Upgraded everything to 2007, and it was like watching maple syrup being harvested when I ran certain codes. Bumped to 2GB of RAM and it made a world of difference. Of course it didn't help when I had Aceess/Outlook/Internet...

Some things I like. Some things I do not like. I've used 97, 2000, 2003, and now 2007. 2007 is a resource hog.