Search results for query: *

I want to import data from a spreadsheet automatically. How can I tell access to import a particular range of the spreadsheet, as in range("A15",range("A15").end(xldown).offset(-3,0))??? I want access to append this data to the bottom of an existing table in my database. Is this possible? I...

I just tried your suggestion and it was a no go. It works without the choose statement i.e., between 50 and 190.4.

Does anyone know why this statement will not work in the WHERE statement of my query??? Choose([1=Low Load; 2=Mid Load; 3=High Load],Between 50 And 190.4,Between 190.4 And 330.8,Between 330.8 And 518) I can't figure it out. Thanks.

I am using Access to send an email automatically, however, it will need to go to a lot of people so I wanted to create a distribution list. With oRpt .to = "Distribution List Name" .send End with Does not work because as far as I can tell, it takes too long for the distribution list...

When I step through this, it thinks the foundfile.count is NOT > 0. However, I know that there are files there because I used the same sPath variable to output them there. This is why I am getting confused.

Can anyone tell me why this might not work assuming that I have the path name right? With Application.FileSearch .NewSearch .LookIn = sPath .Filename = "*.rtf" .FileType = msoFileTypeAllFiles If .FoundFiles.Count > 0 Then Kill (sPath &...

Thank you!

I have tried that syntax, but am getting the error message "Type mismatch" Why is that?

This is the code I'm working with: Dim oCal As MSACAL.Calendar Dim pdCalendarReportDate As Date Set oCal = Forms("Switchboard Subform QC")!ReportDateCalendar pdCalendarReportDate = oCal.Value Debug.Print pdCalendarReportDate Set oCal = Nothing The Set command is whereI...

I am trying to set an object variable to a calendar object that I have created on a form. I can't seem to get this. What is the syntax for referring to a calendar control???

If the printer is available on the network, but is not necessarily selected at the person's who is using the database's desk, do you think that it will still work?

I have some code that automatically prints a report when a button is pushed. Many people will be using this application in different places and I need to be able to print to the same printer every time. I see that there is a printer object, but can I set a particular printer on the network...

No problem at all. Thanks. I'll be waiting...

Is there a way to disable the close button on the title bar?? The one that closes the database, not the report.

How would you make the first form that opens invisible?? I don't see anything to control that.

So how do I say... If application.quit = true then DoCmd.cancelevent elseif application.quit = false then Exit sub End if I know this will not work, but I don't know how to do what your suggesting.

How can I check to see if the app has been exited??

I have some code that prompts people to close a report at a particular juncture. Most people that will be using this particular database may not understand that I do not want them to close the entire database. Is there any way to prevent the application from closing if they should hit that...

Thank you. I had no idea you could work backward. Could you just explain why you subtracted 1 from the count and went to 0? Why not just go from the count to 1?

Is there any reason why this code would not delete rows that have empty cells in the 3rd column after being run only once??? It must be run about 6 or 7 times before all of the rows with empty cells are deleted. Sub RemoveBlanks() Dim oCell As Object...