Microsoft Access / VBA Forum

Hello. I know how to call a parameterized stored procedure by using ADODB command object and parameters, but how can I execute the same query using adCmdText instead of adCmdStoredProc? Namely I created the CommandText string with declare statement for parameters before the select statement. No error is displayed, but also, no records are...

This is such a simple basic thing I've done for decades yet now a problem? I'm sure it's something silly I'm missing. A search provides no answer for my situation. Library reference is to Microsoft Office 16.0 Access database engine object library. I removed that and changed it to DAO 3.6 library. Both compiled. Both gave me the same error. ...

Hi, I have 2 tables and The VMSU-ILt-Main Table contains info about a person on the main form, the VMSU-ILT-Sub Table contains info about the subform on the main form. they both have as ehe linked fied, and I am trying to delete records on both tables by Date, the date is only stored in vMSU-ILT-main table. I am getting error when I try...

Is there a way to reset the AutoNumber sequence? I have several tables that use the AutoNumber field as the Primary Key, and I'd like to somehow do an Import/Export that will make remove the breaks in the sequence. A few breaks in sequence is not a big deal, but I have one table with under 200 records, but the last AutoNumber PK ID field is...

If you're interested in measuring elapsed times in your Access Application, you're much better off using the timeGetTime() API Function instead of the Timer() VBA Function. There are 4 major reasons for this decision: __1. timeGetTime() is more accurate. The Timer() Function measure time in 'seconds' since Midnight in a single-precision...

Using the code below to capture images in Access. On my form is an unbound OLE image and a single button. Clicking the button when a digital camera is connected via USB and turned on causes the camera to take a pic and show it in the OLE image frame. Private Sub cmdGrabImg_Click() 'Take a picture from a webcam and store it in a temp...

Dear reader, The syntax for the VBA code to change the RowSource of a Form is: Forms!FormName..RowSource = "TableOrQueryName"

RE: execute javascript on a webpage via VBA I have a procedure that opens a webpage. What I want to do is click a button on that page, but it isn't really a button. There is a Javascript function that clicking the "button" runs to open a different version of the webpage.

How do I set up a button to remove a form filter. I can get a button the edit the form filter by nowt remove it. I don't want the have the use the remove filter on the records menu Thank you

Does anybody know the syntax for commenting out lines of code in SQL View in Access Query Design? Also how to only run one query or part of a query in SQL View when you may have 2-3 that you are playing with? For example I can do the above in SQL Query Analyzer by -- to comment out and highlighting the query or part I wish to run

Hi there, I recently updated to Access 2007, and I'm getting a couple of errors that i'm not sure how to deal with. I worked with a lot of databases in Access 2003 (.mdb), and for some reason some of these databases will not open in access 2007. The errors I get say: "An error occured while loading 'Form_frm_tabstrip'. do you want to...

I don't know why I'm having problems with such a simple problem. I want to display a message on the screen while a process is going on then turn it off when process is complete. If it blinked while on that would be fine to. Thanks for your help as always.

Hallo, I have developed an application in MS Access 2000 (Polish version) under MS Windows XP prof (also Polish). Now I would like to run this code on MS Windows XP EN and MS Access XP EN. I have converted the mdb to version 2002 under MS Access XP Polish and under this version everything works OK. The problem starts when I copy the mdb file...

Hi all I wrote a listbox onclick event.On a click i want to get the selected row details but the listbox.selected(i) always returns false ,it returns true only in double click event.Are they any other events on which i could do this.I want to populate a textbox based on the row selected from the listbox.Its working as i want when i add the...

Hello, Is it possible to set the value of a textbox on a report in VB when the report loads? Any ideas?

Hi All, I am new to using the Access DB and I need some help if someone is able to give it to me. What I want to do is get the names of the columns of certain tables. Not the data in the table but the table column names. I've seen other posts that suggest using the SQL command DESCRIBE but I can't get it to work for some reason. Other...

Hi, I have managed to simplify my problem but can't seem to get this to work. I want to open up a form from a click event of another form, but not only open the form when the button is pressed but also move to the last record. DoCmd.OpenForm "My-Form-Name", acNormal Opens the form with no problem.....

Hi all, Hopefully somebody can help. In Access 2002-SP2, I receive an error from the VB Editor if I try to compile the following code (see below). The error is as follows: Compile Error: Method or data member not found The follow subroutine is highlighted (specifically .txtNR_Program1):

Is it possible to programmatically get the sql string of a query object?

I'm a beginner user of MS Access, and I am having a problem building a database with a complex form that enters to several tables. I did not use subforms because I am attempting to emulate the hard copy of the form that was given to me by my supervisor. I don't know if that makes my problem impossible or not...

Hi all, I am new to this forum and relatively new to Access. I have created an Access database and I am importing 13 tables via ODBC every morning. I am importing these tables instead of linking to them b/c if I link to them the queries are VERY SLOW. Is there a way to automate the import process thru VBA? Thanks!

I currently have a form with a couple text boxes, a button, and an unbound subform. Pressing the button will assemble a SQL string using whatever is in the textboxes and assign the SQL string to the recordsource of the subform. Unfortunately, doing so results in the run-time error 2467 - "the expression you entered refers to an object that is...

I have a subform datasheet that contains a full year of records sorted by a date field. I'm trying to programmatically move the record selector on the datasheet to the first record that matches a particular date. For example, the user clicks a button and the record selector moves to the first record that matches today's date. I was...

Does anyone know how to use VBA to relink tables between two MS Access databases? We have two databases, one with VBA code and the other with data tables. The tables are referenced by linked tables in the database where the code resides. If we move the database with the data tables to a new directory, the links are no longer valid. I...

Is there a general method for detecting that a user has changed the record currently visible on a form, whether this is by hitting PgUp or PgDn or clicking on a navigation button, even if no change has been made in any control? I'm thinking of a situation in which a number of records have been entered on a form and the user is cycling...