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

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

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

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

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

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

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

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

I am trying to create a search on a recordset that is based on a SQL string. If the search comes back with nothing, then I want to exit the sub routine. What am I doing wrong??? strSQL = "SELECT NGSCommunityCommitmentTons.ID, NGSCommunityCommitmentTons.Unit...

I have a button on a form that opens the appropriate report, but I want the report to default to 100% every time it is opened. How can I accomplish this?

I have created a chart sheet using VBA in excel, but I can not figure out how to input the data I want to graph using VBA. Can anybody help me?

I have a form that has some entry fields on it. When the focus is lost on a certain field, a search is initiated, and if duplicates are found, the fields are returned to null, and I want to close the form. The problem I get is that there is a run time error 2585. "The action can't be...

Does anyone know how to open a report in VBA when the report requires parameters to be entered before it can be opened? I would like to do this by referencing the parameters in VBA with a variable. Is this possible.

What is the syntax for the inputparameters property in access? I am trying to have a report open based on the parameters I specify for a form without having to re-enter the parameters. Thanks.

Does anyone know how to get rid of the message that pops up whenever something is sent automatically through outlook from another application? I do not want to have to push yes everytime I run my code. I've tried disabling alerts, but that doesn't work. Any advice????

I'm trying to send an access report to someone by pushing a button. It is output to a file already and I want outlook to add it as an attachment. My question is, what are the "source" and "type" arguments of this method!?!?!? I am using the mailitme object of outlook...

Are there any ways to add VBA code to a query event? For instance, when I open the query, run the code.

I need help displaying the 30th record in a table. I don't know the language to get the query to display the 30th record each time (the 30th record will be a different value every day). I would like to have this record displayed in a message box. Does anyone know how to do this?? Any help...

I have created multiple queries that perform calculations on several tables. I would like to store these calculations into a new table. I can't seem to get this to work. I think the problem lies in the fact that my original tables that I am performing the calculations on are linked from...