Register and Join the most happening forum of Sikh community & intellectuals from around the world.
I have 12 fields in a form (H1, H2, H3, etc). Each field has a button that
can be clicked to perform an action (move all the values up one space,...
When exception (debug or End) occur all of my global variable resets!
How to prevent it??
I am trying to move some of our large VBA Access front-end file into
ActiveX DLL files. I created two DLL files so far, one was a module
Here's my situation: I have a form that has several combo boxes that a user
selects a "code" for different things. These codes are stored in...
I have a report total sales of some firms.
I need, in the report, to be able to access a single sales of a firm,
which is stored in a...
Please help for converting a numeric variable to a character variable in
access. Thank you.
I have a variable name ID, it is a numeric...
I capture the userID in my login startup form. I then set it = to a publicly
declared variable currentuserID. I tried to use the currentuserID...
Is it possible to refer to a public variable declared at module level in a
query and in a control (both report and form).
I've got a value box (list box) where multiple choices can be selected.
I want to save those to a variable that I can use as a record set
I have 5 text boxes on my form, each with the max length set to 255
characters. On the AfterUpdate and KeyUp events for each text box I will call...
I receive a "Out of Memory" error in my VB module when trying to update
a table with data from an SQL query. I receive the error when trying
I have written an event procedure to run when a user clicks a command button
in a form. The button press is supposed to engage the action to make...
I'm trying to create a new report in access but keep getting the message
object variable or block variable not set, I've tried using a table as...
Can I pass a variable via command line like this....?
I couldn't figure out how?
I am trying a work-around to get my subform to gotonewrecord when the "New
Record" button is hit on the navigation button. Work-around: create my...
i have a table VAR with a variable POS containing a numeric value
(representing a cursor used to print forms beyond this value).
I am trying to build a query that pulls the maximum number of orders
over a period of 3 days. Could anyone help me out?
I have done this before but forgot how.
I want to assign "Smith" to a report textbox with a programed defined
Dim strSuffix As...