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

I won't get dragged into an Iraq debate. I don't think we should be there, and if we *had* to go in there for some reason, we did it all the wrong way.

You're the one preaching hate, you've already used a number of insults and epithets regarding Americans today, so why would I believe any different. All I can go by is what you type on here. I'm just telling you to celebrate. Americans were killed, you should rejoice. And if you forgot it...

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

Well since you could really care less for Americans, crack open a pint and drink to the 32 deaths of those you hate, and be glad there's less of us to deal with. You can even write the Korean Embassy and thank them for removing some of the scourge of the earth.

Thank you for making my point. You are clueless. How about this? I won't tell you what kind of whiskey to drink, and you don't tell me what I can legally have or not have in my house.

Well then, explain Kennesaw, GA to me. Oh expert of all things.

I could. You couldn't. You lack imagination.

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.

Again, not a need, a CHOICE. You could be involved in a different business. Again, I see that inablilty to grasp simple concepts popping up again. And yes, I could with the air rifle or paint ball gun. Maybe you don't possess the knowledge to do so, but it CAN be done. Again, get your facts...

Google will tell you more than you need to know about making a great number of explosives. ;)

We aren't talking about YOUR country. We are talking about the USA. You said it's not possible. It is. You might want to get your facts straight before telling the rest of us what we should or shouldn't do.