Is it possible to call a private sub let's say 'mysub' on 'myform' from another form 'myotherform'?
The call statement would look something like: myform.mysub in the code for 'myotherform'
I can't seem to get pass-through queries to accept arguments from text boxes in forms. Additionally, I have many queries and would like one location to change DSN/UID/Password info, rather th...
I NEED VBA CODE TO HIDE STATUS BAR AND MENU ITEMS. DATABASE NAME IS CREVIEW. THIS DATABASE DOES NOT HAVE "TOOLS "MENU ON TOOL-BAR ON THE TOP. I NEED VBA CODE TO IMPLEMENT WHEN CLIENTS OPEN ...
In Access 2003, I have a field called DeptCode already created and want the display control be converted from Text Box to Combo box. Row Source to be: SELECT PROJ_DPT.Dept_Code, PROJ_DPT.Dep...
I have a command button intended to save the record and subform records on a form.
The subform has code in the before update event that test for null values and prevents the user from pro...
I need to change the way a certain field calculates data, but at the same time not endanger the 5 years worth of historical data that reside in the underlying table.
I need to create a for...
I have a stored procedure on my SQL 2000 box, the procedure needs two parameters.
The stored procedure is below
CREATE Procedure GetPlanID
( @PlanDate datetime,
@Client...
I have been coding in Access 2007 and it has been coming up with the errors;
"There isn't enough memory to perform this operation. close unneeded programs and try the operation again"
Exam...
I need to find (2 spaces) and replace with (1 space) in a text file before using a TransferText on it through code or queries. How would I do this?
I code normally in Visual Basic 6.0. The textbox control in VB has a multiline parameter and the maximum text length seems to be very large (64kb I think) However, in VBA (Visual Basic Acces...
I have a database that shows a splash screen on open while it runs some background scripts to check versions and pre-load some information for the user. How can I make it so when they open th...
Dear experts,
Using a reference to MSINET.OCX and the code in the snippet I am able to FTP files to an FTP server. This works wonderfully.
However, I would like to know if there is some...
I have a report that feeds directly from a query. In the detail section of the report, I have a label ("ProdNotes") and a text box ("Comments"). The goal is to allow the user to click on "No...
Hi, I have 3 queries that are doing some computations. 2 of them are SELECT queries that I'm using to store values in. When I call these queies using docmd.openquery, the SELECT query windo...
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...
Dear Expert,
I am very new in ACCESS 2003.
I have a table with three columns: ID, Region and Location, in this table one Region can have multiple Locations. I have a list box for my Region c...
Is there a way to import an xml field from an xml file into a variable using VBA in Access 2003?
I have a form that is driven by a query to display data based on a numeric value passed from a hidden form. Once my users input data into this form, in the footer of the form are a series of c...
I need to create a csv file, pipe delimited from a query.
I created a macro
Transfer Type: Export delimited
Table Name: MyQuery
File Name: c:\tmp\MyQuery_pipe.txt
Has Field Names: Yes
...
I am trying to create a Printable report which will have different information on it depending upon what product has been selected.
This is my current code:
If Make = "AVG" Then
...
I need to prompt a message if no selection is made in the list box (listReport). The rest of the code works perfect if I remove the portion that confirms a list box selection.
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...
Hello,
Long time searcher first time poster....
I have an Access app that I am building and I am having to do some custom VBA coding. Problem is I found my solution, but access crashed bef...
I am just using a simple query to decide what the most recent file name imported into the database is. I then try to use this value in a string (to name an exported file) but I get run-time er...
Hi experts,
I have a query on my form that updates a field on the same form from an OnClick event in a list box. Where there is a value from the query it updates the field ok. Where there ...
