Using VBA code, ADO, and Sql Server, I get "Timeout Expired" when trying to find a record in a table. All other machines are executing the same code, updating different document records. The...
I have a recordset based on SQL connecting to AS400. How can I COPY that recordset to a real Access table without having to read/write each field/record? Anything similar to COPYRECORDSET in...
Thanks in advance and please let me know what add'l info you need
I have an Access 2003 parameter query (see attached file). In that query is a parameter in a criteria field that in some cas...
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...
I have a button on a form that will delete the current parent record via Me.RecordSet.Delete. This parent form has 5 subforms. Each subform is displaying a record associated with the parent ...
Hi,
I am creating a database which is unbound using VB to amend the information.
I have built the relationships up but instead of using autonumber I am manually adding the number to the...
Windows Vista Ultimate, Access 2003. My Access application consists of a main form with a subform. The record source for the subform is a linked table. Users enter partial/approximate data as ...
I am importing data from a CSV file into an Access Table. The data sometimes contains duplicate records. The access table has a multi-filed index that effectively prevents the duplicates fro...
I have a table with a date field, a field called "cate". In the "cate" field some records contain a number either 1,2,3,4 or are blank. I need to create a query that if the date field has a da...
I am having an issue with the Open Method (ADO Recordset).
The line:
rsStudents.Open stQuery, con, adOpenDynamic, adLockBatchOptimistic
In the snippet below returns an error of "...
I copied an Access database from one folder on a seperate server to networrk drive where users can access it. When the users click on the macro, it does not work on their computers. Instead, i...
I will like to compact and repair my database each time it closes automatically. Is there VB code that can be used to perform this task. How will this code affect the database if more than o...
Working on databases (multiple) that are linked via ODBC.
Getting the error message listed when trying to open link.
Can set up the link and open it fine while in Access, but once user gets ...
I have a file that has a employee id and information concerning that user's access rights.
>>>>>>>>>>>>>>>>>Below is a copy of the file.
12550 Password Expires (days): 79 Status...
I'm working on an MS Access application that cycles through email addresses and sends an email w/attachments using the CDO message handler.
It works great for email addresses on the local ser...
i want to get a field value of a subform.
I get the "No current record", when I try to access it.
via
Form_subform.Recordset("FIELD")
in the first form code
the record is displayin...
Hello. This is something I've tried to do several times in the past, without success...
I have a small Access 2003 mdb app that I've developed for a small biz. As they may changes and req...
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...
My problem is thus, I added a dropdown box and linked the calendar control to it, I put in the code to have it popup to pick the date, but when it pops up i see the calendar but cannot pick th...
Hi,
I have a textbox on a form (txtCurrentBill) where I would like to display the user's current bill.
I have globally declared the the unique Account number (lngBarNo) based on the logg...
Hi, I currently have Sales information stored in an Access Data table. This table has the names of all the Salesman in the field "Salesman". I want to export this data to excel on seperate s...
Hi, I have a routine in my application that presents a list of Outlook folders to the user, they then select one and the routine goes through each email in that folder and processes it.
It ...
Please help... I have really been struggling to correctly code my save event procedure. I have searched the EE database, looked at Allen Brown's website... and I just can't get the coding righ...
I am having trouble creating tables and fields into a secured database that i am dymically building using VBA and a master DEV database. This code does create the secured database just fine b...
The below code is intended to delete the form record. The subform data is deleted via the "delete cascading records" relationship option. The button works with no errors and the final messag...
