I have 2 users. Each have a copy of my Access.mdb on their own computer that uses linked tables. The linked tables are in another Access.mdb elsewhere.
If both Users have my Access.mdb ope...
I have a form that has a combo based on tbl1 - if user types name not found in the combo- I want to be able to automatically add to the list. I tried both bound and unbound fields - still hav...
I am supporting a Microsoft Access 2003 Application that uses VBA, a Word Template and Mail Merge to produce a report. The Access application sits on the users' desktop's while the Word Temp...
Hi experts,
I have a custom dialog box that I use to get input from the user. In this case, I ask the user to provide a ticker, which is a four letter alpha string. I need to make sure that...
Hello,
I have a form, which has a button [cmdNewpatient]. If a user clicks this button I would like a message box to appear asking "Do you want to add a new patient" - with the options Yes/...
I am using a subform which I bound to an SQL string to display a filtered datasheet of records for a specific client. I am using the code shown below to bound the form to the SQL. The tbl-pe...
Hi experts,
I'm writing a procedure using VBA in Access. What I want is to select the records from a table with such condition that the values in a specified field do not equal to any of th...
I'm trying to launch Outlook from a form within Access, can can't get the VBA code right.
Also, I'm trying to open the calendar and tasks in new windows.
Here is some sample code I was inv...
I have an Access database with tables linked to SQL Server. I'm using Access as a front-end for forms with Visual Basic.
Using an ADODB connection, I am getting an error executing an UPDAT...
I have a query named TasksLogPeriod created by hnasr, that does calculations for how long a each task has been active and inactive. Using that data, I have created rptTasksLogPeriod intended ...
I have a legacy form function that populates a combo box using a hard-coded select statement. It is noted below as Existing.
I want to simplify maintenance by referencing a stored procedur...
I need a report for the length of time each task has been active based on the three (3) queries, TasksLogActive, TasksLogInactive, and TasksLogPeriod. The queries were developed by hnasr for ...
I have an Access macro and the code below is part of a module that is one step in the macro. I need this step to finish before the next one begins. I am using the Run method and thought my p...
Hi, im currently havn difficulty with the order of events with my VBA Code.
Basically when a user clicks on a command button it should open up a form and subsequently print a report. The da...
I have a problem with the attached code. It gives the error message "Too few parameters , Expected 1. I am trying to determine if the query returns any records, an if not to display an error m...
I have an excel vb script which dumps data into a table on sql server. I am reasonable with vb so thats not the problem.
Now, I am creating forms in access 2000 to view those records and if n...
I have a table with two columns. Column 1 - PIN#, Column 2 - ID. Each PIN# can have multiple ID's. (ie. PIN# 10051 has ID 276 and 319, however they are listed on seperate rows) What I am t...
Okay, Experts, here's my latest conundrum:
I cannot seem to set a validation for a column in an Excel spreadsheet from Access. This file is being programmatically created from Access durin...
I have an MS Access 2000 application running on Win 2000. It is on a network drive and used by multiple users (it is not multiuser application). It is not an .exe but normal .mdb file. The fil...
PIPE INVENTORY TABLE
===================
Pipe ID
ASL #
...Other Pipe ID Details
Two peices of Pipe are welded together and the information is stored....
DOUBLE JOINT TABLE
=========...
I have a table where I want to concantenate multiple fields and separate each of them by a comma. The only issue is that some rows have for example 3 fields, and some have 5. See example bel...
I submitted a string of code below: it is supposed to search my table ("StudentName") for all records where the field "NumberStudents" is null and StudentName = "Tom". I can not get the "Null"...
I have the following code and want to run it from the sub:
Private Sub Form_Load()
I am new to VBA and appreciate any help. Thanks.
Artie
My question relates to whether there is any way of improving the attached code as it seems to take a long time to operate.
The code is translating (with a few tweeks) an imported txt or cs...
I am generating SQL code in Private Sub CloseForm_Click() and passing it as an argument, strSQL, to the form, "2007 Job Log" which I open inside CloseForm_Click() with the following command:
...
