Microsoft Access 2003: I have a form that shows what days of the week physicians work. Presently, my form header consists of the days of the week as (S M T W Th F S) using labels. I w...
I have a form that populates some data from a query. On that form is a subform. This subform has a listbox that needs one of the results from the parent form's query.
For example, my parent...
I currently have an access 2003 database that automatically creates an email in outlook 2003 using the .htmlbody body function. I have figured out how to format and insert data using html cod...
I current have a Visual Basic Module within MS Access that I output the results of an MS Acceess table to an MS Excel spreadsheet. My problem is my output is now over 65,000 records so I want...
Hi All,
I have a small access application developed in Access 2007. Every time I run it on a machine that has no access but just the run time files(downloaded from Microsoft site) it pops up...
I've got a Sharepoint list linked into an Access 2007 database. Through code I'm trying to update fields in the list, but get a message saying "Database or object is read-only". I realize it...
I want to generate a report from the database in Access by writing some VBA code.
I will have a Form containing a text box where I can enter the ID, and by clicking "Enter" the system will ge...
Hi experts,
I am trying to disable the shift key in my MS Access 2003 application so that users cannot bypass the runtime MDE properties and access the design view where they have a full ve...
Been working with Access for some time now, but only really "basic" stuff. Have been reading and coding more with SQL, DAO and ADO, but need some tips/advice on when to use each...
For "ba...
Hi,
My table is in access, and I need help in transposing the following format:
Lodge# Year Jan Feb Mar Apr
1 2007 10 15 12 20
Into this:
Lodge# ...
I have created a recordset using three tables and criteria received from user input on a form. I would like to be able to view the recordset in a datasheet. How do I create a view for this r...
Option group (optTransportType) is on a form is and is set to null by default. In the Before Update Event of the form, I want to check optTransportType to make sure that the user has selected...
Is there a way in access to convert a date from 09/27/2007 to YYYYMMDD to be used for date comparisons?
User needs option of inputing a Canadian postal code or US zip code in the postal code field. The mask must allow either type of code but prevent any errors. Application is for small busines...
Near the end you'll see >>>>> It's happening here <<<<<<< what I'm trying to do is check to see if there are any records returned from the sql if so step into the IF statement and produce a...
If I've created an Access Database - which contains a form - is there anyway I can write a vbscript which will connect to this database, and open the form for viewing its contents(read only)? ...
Is there a function to check/enforce that a string is a valid Windows filename?
I am generating an Excel spreadsheet via OLE automation and the filename is based upon the customer name as e...
Using Access 2003 VBA. I need to take a table that has one record in it. It has 10 fields.
Each field contains a number.
I need VBA to read the numbers in this record and then create ...
The field contains characters that I think are carriage returns. The character looks like a square. I cannot do a Find and Replace. I'm able to highlight and copy the character into notepad...
I am trying to schedule a distribution of a report to run in ACCESS every Monday morning. I have a module in ACCESS that does the logic I need and it works. However, when I try to schedule i...
I have VBA code that exports a table to Excel, creating separate workbooks for each group. I also want to add totals and place them in the next available row. Can someone assist. I setup ac...
I have tried implementing the code provided in the following solution for multiselect listbox:
http://www.experts-exchange.com/Database/Miscellaneous/Q_21989025.html
My code is attached to...
I've pasted my SAP GUI script into a Microsoft Access module. the script works if I run the .VBS file from my desktop, but when I try to run from within Access, I get a comile error 'Method o...
This macro works fine in Access 2003. It is attached to a button on a form. When the button is clicked the user is asked to enter the parameter for NC number. The query runs and the record...
As I add VBA code to an Access 2003 module - I find myself hand-typing the following code often: Is there anyway I may automate this and if so, how? I am unable to buy the add-ins the market...
