Search results

How do u link all the subforms to the Mainform? HTH

The end of the code is quite messy, as is. And what is "DoCmd.RunSQL strSQL" supposed to do there? Maybe this version would work better: recSet1.Close con1.Close Set con1 = Nothing Set recSet1 = Nothing End Sub Also, I'm not sure about your quotes in: " WHERE ShipperName = " & " '" &...

Ok, several issues: 1. The loan details should be in a subform 2. The movie combo should be bound to MovieID, not MovieTitle 3. The Rowsource for the movie combo should be something like: "SELECT tblMovies.MovieID, tblMovies.MovieTitle FROM tblMovies ORDER BY tblMovies.MovieTitle;" 4. You...

Well, for the file picking routine u could check out "Filedialog" in VB help. Then u can save the path to the .txt file in a hyperlink field, so when someone clicks it in a form, it'll open the associated .txt file. HTH

Well, yeah u should create 1 table with facility specific data (AutoNumber Primary Key named FacilityID or something), and another table for the rest, having FacilityID as a Foreign Key. Since some of the data to go into the 2nd table is optional, u might have some blank entries, but it'll still...

Well, it's not very clear what you're trying to do; could u be more elaborate?

Well, u could use a Group Header and move some of the fields to it. HTH

Well, Mate, you WILL have to go under the hood for this one. HTH

U might wanna take a look at this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=138021 HTH

Have u already checked out the Classify and Group feature in Access Reports? HTH

Well I can't see how and why u would use 3 queries at the same time on the same report. Normally u should have just 1 query to populate the report. The total sum text box should only contain the sum function (for ex. "=Sum([SubTotal])"). The text box that displays the number in words, should...

Well there are several ways to do this. I'll give u one of the easiest here: In design view, select combo122, go to data tab and clear the line for ControlSource (a lookup combo should be unbound). Clear the line for RowSource and add the following code to it: SELECT tblFriendList.FriendID...

U might wanna copy this code and save it in a module: Option Compare Database Option Explicit Public sMainForm As String Private Declare Function apiGetSys Lib "user32" Alias "GetSystemMetrics" (ByVal nIndex As Long) As Long Private Const SM_CXSCREEN = 0 Private Const SM_CYSCREEN = 1...

Well normally your FTP software can tell u that (presuming u have FTP access to the customer data). HTH

Well, no, "tblParts" is the table the data is in: just replace it with the actual name of your table. Likewise "fldPartName" is the name of the Column you want to get the data out; here too rename it with the actual Column name. "fldPartNew" is up to u, since it's a new field you're creating...

Ok, try it the VB way: Sub cbo1_Afterupdate() Me.cbo2.Rowsource = "Select ...." Me.cbo3.Rowsource = "Select ...." End Sub Sub cbo2_Afterupdate() Me.cbo1.Rowsource = "Select ...." Me.cbo3.Rowsource = "Select ...." End Sub Sub cbo3_Afterupdate() Me.cbo1.Rowsource = "Select ...."...

Well, for starters, Combo11 on subForm should be bound to MovieID, not MovieTitle HTH

Well u could check out the move method in VB help. This way u can have each form open on the same spot. HTH

Well, for starters, I can't figure out how u manage to put clothing items and colours in the same table: it'd be easier to have just the clothes in your table and the colours could come from a list of values, but anyway here's what u could do: Concatenate the values from the 2 boxes, and put...

OK, now you're talking. The best would be to create a form with a textbox (txtSearch) and button (btnCreate). Add the following code behind the button: Private Sub btnCreate_Click() Dim db as DAO.Database Dim rs as DAO.Recordset Dim sSQL As String Set db = CurrentDb() Set rs =...