Calculate1111 (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 Please397 (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 table1100 (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 table2327 (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 sql4122 (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 question5221 (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 up1145 (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 VPN6228 (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 table2123 (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 record2378 (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