I have a field containing a FedEx tracking number.
Is it possible (and if so how) to create a cmd to send that number to the FedEx website:
http://fedex.com/us/
fill in there tracking numbe...
I have a database that has a button that executes an Append query. I want to suppress the information messages it gives as the process is implemented. I want to click on the button, say yes an...
When I use this snippet of code, 584 records are returned (which is what is expected)
Set db = CurrentDb
Set rs = db.OpenRecordset("Contacts")
MsgBox rs.RecordCount
However, ...
i am trying to update all records where the field named Balance is empty in the table called Checking
but the below code doesn't do anything as far as updating the empty fields goes
if y...
Hello Experts.
I am looking for the best method to flag an MS Access record that has been changed. I want to be able to run a query that will only show records that have been changed since...
I have a database where there should only be one occurrence of any particular name, and I'd like to be able to check for duplicate values as name information is entered in a form. Specificall...
I am trying to get Access to ouput SELECT query results directly into a named range in Excel.
The code below is my 4th different approach. This one almost works, except it wipes out the en...
I need to add a button to the main form of my database that will prompt a user for a location and then copy the database to that location. This is a reporting database and the data is only up...
I continue to get errors like these: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
The record ...
Hi Everybody,
I am having a problem with OLE BoundObjectFrame in Access 2003.
I created a boundobject called "bOLE", which is bind to the recordset of the form. I presumed that if I...
I have a standard VBA application, split front end/back end. I just upgraded to Access 2007 because more of my clients are doing so and I wanted to feel more confident that the application tha...
I have a subscription based site and application. I want my application to be usable only as long as the user is subscribed to my service. I want the application to lock itself if the user h...
Hello,
Please follow this link:
http://www.mvps.org/access/datetime/date0012.htm
I have already implemented all of the functions into my database. Everything works great. Now I'm tr...
Hi,
What i make is an access macro reads from excel and insert into a table'student' all duplicate values removed wrt student id.I attached code below.
Same way i need a form when we cl...
I am writing a macro in Access 2007 and need to use the PrintOut action. However, it is not one of the action options. The database is in a trusted location so theoretically this action shoul...
I keep getting an error when I attempt to run the code below. The error states: "Run-time Error '13' Type Mismatch".
The query "qry_cycle_sonum" queries a table and has a result of one c...
This one is driving me mad. Can anyone explain what I am doing wrong in the attached code? It fetches whichever email is open in Outlook and saves it as a msg file and also extracts the sender...
Hello Experts!
I'm sure this will be an easy question for you brainiacs....
I have a table with one field in it called 'Buisness Date'. All I want to do is ask the user for a past date ...
I want to set a validation rule for a form to either accept 7 digits or a null valule.
This weekend I had to reinstall Access 2003. Before that, Ctl-Break worked fine in stopping any running VBA code. Now, Ctl-Break does nothing. I checked Options and couldn't find anything....
I have attached some code that I use to create an Excel spreadsheet from Excel 2003.
It works and I end up looking at a formatted Excel spreadsheet.
But, when I insert the following inst...
What could cause vba code execution to simply stop without an error?
I have one user running Access 2000 that attempts to export a report in snapshot format using a procedure I've attached to...
I am using this SQL statement to delete a table in Access. I want to Append the table to Table2 before deleting it. The entire table. What SQL statement would be best to use and how?
With D...
Hi Experts,
I'm having problems with an error message all of a sudden to open a form that is linked to criteria. When building this database, I had several backups along the way and they al...
Access 2003. I want open a second database in my application mdb using the opendatabase method. The second database is in a different workgroup and has Access security with a username and pa...
