Calculate 1 111 (5/3/2007 8:48:39 AM)
Below are my VBA coding:- Sum=sum+1 Me!QtyKitted = sum My textbox is QtyKitted. But the problem is my control source is QtyKitted because I need to use it to generate query. May I know how to make the textb...
EMILYTAN

Connecting Info from 3 forms into 1 table - Help Please 3 97 (5/3/2007 2:17:09 AM)
I am trying to get data from 3 separate forms to display in 1 table. The 3 forms contain separate text boxes that should connect to the one table. The table seems to be only saving data from the first form. The...
rblivewire

Combining query and table 1 100 (4/30/2007 5:23:02 AM)
Well, I have a table with fields like Quantity Borrowed and Quantity Returned. I have a query with a field QuantityAvailable which is calculated based on some formula... So, problem is I want to build a subfor...
EMILYTAN

Form Code to append results from query to table 2 327 (5/2/2007 7:32:41 PM)
I have a button on a form that thru code will run a macro which will run a query. How do I get the results from that query to append to a table, all through vb code of my form? Thanks, Frank -- Message post...
Frank

Help with sql 4 122 (5/2/2007 5:02:29 AM)
Hi I have been given a rather hairy piece of sql to put into a module but I have not been able to properly convert it to SQL that access can process. Can anyone help with this? The sql is: update cdb_data a...
Sandy

Main form, Tab control, subforms and a query question 5 221 (5/2/2007 6:33:10 PM)
Hi All, I am trying to build a main form, that will have a tab control and 2 pages each with a subform (the easy part) . I have this already, but I have 2 seperate forms and 2 query's for the tab control page...
Corey

Date Validation pop up 1 145 (5/2/2007 6:48:46 PM)
Hi Everyone, I was just asked to create a date validation pop up on a form that I'm designing. The validation is a pop up box that asks the user if the end date of the period is correct by taking the last date...
NoviceNana

Access via VPN 6 228 (4/30/2007 10:10:44 AM)
Hi Alll, I have an Access database on branch office (other country) I need to connect from oother place via VPN. What is the best method to connect Access database via VPN? if possible to connect direct via VPN...
yanto

Update combo from table 2 123 (5/1/2007 9:08:01 PM)
Hi, I am working on a database I did not create, always fun. I have a form with a combo box on it for client name. There is a button to add a new client. When you click on it, it brings up the table and yo...
Utf

Check for record 23 78 (5/1/2007 7:38:00 PM)
I am using the following code to determine if a record is present, then doing stuff accordingly. Trouble is...I do get the message if there is a record and do not get the message if there is not. Am I doi...
Utf