Search results for query: *

Thanks everyone! I'll try all suggestions. As for now I went the long way and updated a temp table and then updated the the main table by way of external query. Thanks again. You all are the best.

I am fine AceMan1 and you? I tried adding the space but it did not work. The second post is not too clear for me. I see how you broke everything up but it seems the same except that both strings are "SQL =". Does that mean that I should create both queries and put them together into the same...

Sorry if this question has already been answered but I have been unable to find an answer that pertains to my code. Here it is...I created a select query built on the fly from a field on a table. I need the query to supply information that will be used in an email. I then however want to update...

I just found the error. I had a subform that had lost its "recordsource". I pointed to the correct table and all buttons are functioning. Thank you so much for your help.

I am getting the following error message. I have checked my references...fine. I just have a button on a form that when clicked run code in a module. It does not even make it to the first line of code on the form. It seems to be stuck understanding the "On Click" button. I have other databases...

Thank you...Thank you...Thank you. I have been looking for this for a while. It worked. Oh, I did try the other forum first and then they referred me to this forum. Thank you again.

I am using VBA via Access and I am trying to print the current screen in my host system - Extra! Enterprise 7.1a. Can anyone help? Thanks

I saw this before but my network printer uses an IP address not a network name. Any hope there? I am coding in VBA through Access. Also, thanks for all your help.

Try taking the row and col out and just leave 1,1,2,2 and then check your variable. It should then have a value. Set variable1 = Sess0.Screen.area(row1,col1,row2,col2)

It still does not work. I have tried everything without any luck. Do you know of any other way to just send the current screen to the printer?

Thanks, but that does not work either. It actually puts <PrintRange> on the command line. I tried to put an enter in there and I get a CL002 unknown command. I used Sess0.Screen.SendKeys ("<PrintRange>")

I have a module in Access that screen scrapes and enters data in Extra! Enterprise 7.1a. I cannot seem to find the command to print the current screen. I even tried setting a shortcut key to print and then using the sendkey command but it still does not work. Does anyone know how I can...