I am currently working on "filtering" out microsoft access shortcut keys from my database. The reason is, some users are having problems by, for example, using the arrow keys while a cursor is...
Hello,
I have a combo box that when I select a value from the drop down, the value is used to change the criteria in a stored query. But I also want this to work as I am typing text into th...
I have a SQL statement that works as an embedded query. The problem is when I try to port it to VBA the ampersands aren't acceptable in the WHERE statment:
"WHERE (((Now()) Between Format...
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 ...
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...
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)...
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...
MS Acces 2002 - is there any way possible to code on a form text box to pull value (calculated number) from a report based on a query without having the report open?
Thanks much!
I need to pass 2 combo box values from a tab form to a parameter query, that is run after these values are selected when a command button on the tab is executed, to find the maximum project n...
Hi - I have an field on a form named "Image." I'd like to place a browse button beside this button that will enable a user to navigate/find an image on the computer'd hard drive. Then, I'd l...
I have a summary table of one liners of text, and I'm trying to load them as the memo field in another table.
I'm doing it by first finding the size of the summary table, then building up ...
I have the following code (see attached). I need the proper coding to refer to the "stNewWKSH" in my form "frmClientList" after opeing and going into the my form "frmWKSH". If stNewWKSH = Yes ...
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?
I have a script for a table call test in Access look in a field call LIN for null value and copy the last none null value until next none null. I need this to loop until there is no null in t...
When would you want to use Docmd.Quit acQuitSaveNone instead of DoCmd.Quit?
I'm getting the error "Data type mismatch in criteria expression". My code is almost completely from the book and I'm feeling very incompetent. If anyone can debug my code, I'd really apprec...
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 have a table with a bunch of names in the following format: (Last, First) (i.e. Sampson, Brock) Sometimes there are extra spaces after the comma.
What query or code could I use that would...
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 ...
I need to generate a series of excel files (just spreadsheet no charts etc) from VBA in an access form.
I have followed the examples in the help as well as online, but I get an "Object variab...
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 ...
