Hi, I have an Access module that parses data and creates individual spreadsheets. I'd like to add on the first 4 rows of the Excel spreadsheets some header information (i.e. company name and ...
is there a way to include my variable ts with whatever the user types in the parameter box?
thank you
Dim ts As String
ts = Now
DoCmd.RunSQL "INSERT INTO NotesTable([Notes])VALUES ([Ente...
MS-ACCESS-2003: VBA Modules & Macro that runs them.
I have a Macro that does a number of steps. After the Macro has completed all other steps, I want to implement a "last step" in the Ma...
I am getting a syntax error on this, and similar versions, please advise. Thank you.
dim strVal as string
strVal = "Joe Smith"
docmd.applyfilter("filterName"), "fieldName1=" & strVal
Hello,
I have a form which contains a listbox with a number of tabs (peoples names) I'm trying to change the source or query of the list box in the onclick event of the tab. I've never used...
Hi
I have some tables in Sql2005 and have linked them to my access dabase . Now I wanne to read information from textboxes and add new record in my table. Also I want to show User a massage t...
Using command button on continuous form then runs VBA. In VBA I add record to recordset using DoCmd.RunSQL Insert query, and then requery the form. I then want the form to activate the row...
I am trying to rename a table the top technique in my code works. The other 2 produce an "object invalid or no longer set error"
Any idea why one works and the other 2 don't?
Thanks,
...
hello there experts,
i have an ms access application. i want to sell each copy of it to some people-customers. i must somehow lock the access application.
what i have done is this.
1)...
Hello,
I am trying to write code, so that when I press a button, it will auto generate 5000 unique numbers based off the last record in my table. For example: the number in the table is 50...
Hi Access users.
Does anyone know how to get a Form and Control for the current form I am editing in design mode?
I want to add a button on a toolbar that I write VB code for, so when...
The author of this database has been fantastic. I would like to make a log of the VBA changes long-term. Since I did not write the changes, I am not sure what they were. Is there anything "...
When I run a query using docmd.openquery queryname, if an error occurs, a dialog will appear. To keep things neat, I usually set warnings off and let the query run. However in this instance, I...
I have an excel workbook with 5 tabs. I want to import all into their own table.
Here is the name of the excel file : Premier Measures Oct 07 - Mar 08.xls
Here is the names of the tabs...
I am using ADO to open recordsets, and my RecordCount always equals -1 even if there are records in the set.
Any thoughts?
hi, i am trying to use the Count function in Access VBA but I cannot get the Count function to work
here is my code
DoCmd.OpenQuery ("Query1"), acViewNormal
Count ("Query1")
MsgBox Count...
When would you want to use Docmd.Quit acQuitSaveNone instead of DoCmd.Quit?
Sorry in advance if this seems a bit long...
I am a Chemical Engineer who has also been developing Access DBs since the mid-90s.
I use Access DBs to manage the multitude of information tha...
I am trying to run a query that will look for things that are current day -2, back 2 days. The query is pulling from a link excel sheet. An example of a date inthe query is 8/18/2008 1:21:24 ...
is there a way to use a created sql string as the from in a Select statement.
ie. Select * from strsql where number = 1.
What would be the correct syntax?
K
Hi
I would like to open a table from a form and, when a certain button is clicked, open another table, go to the last record and display the value in a messagebox. The problem I'm having i...
I use sendobject (acSendNoObject) with no problem in an Access 2007 DB. I am now attempting to email a report using sendobject (acReport). Each time I attempt to run the code from a button i...
I'm successfully creating Outlook tasks from Access. But if Outlook is closed, I get a warning message that is misleading, even though the task is still successfully created in Outlook.
The...
Please give me the code behind a button on a form (form is named "WoundData" ) that will call up a browser window from which a user can select a file, the text of whose path will be transfered...
Hello,
I have an email script that i use to send emails via access through outlook. It works fine with one attachment but I can't seem to figure out how to send multiple.
I have up to 4 ...
