Search results

I have several fields in a recordset and I copy each one individually. Is there a way in VB to copy one recordset to another. Example: rstblSingle![intCourtID] = rsCourtTbl![intCourtID] rstblSingle![intCaseID] = rsCourtTbl![intCaseID]...

I have a table that has many fields on it. I am planning on using a tab control to break in up in "pages". One of the "pages" is too long, and forces the tabs up on the screen. You have to scroll to see the tabs. I would like to put this information in a subform so that you could view it...

Multiple users jimbrooking, Do you have a sample database that illustrates multiple users with a login form. I just don't understand how to keep track of each user logged in. I am trying to give various levels of access. Some users have complete access, while others have limited access. I...

I'm working on a project, where I need to justify moving from Access (as a split database) versus an Access database that uses a Web browser to access the database (probably will be developed with Dreamweaver). I'm interested in advantages and disadvantages of both implementations. If anybody...

I am attempting to use a wizard approach for the input of data into my database. I have a master form and it contains a subform. The subform changes as the operator navigates through the wizard. I change the subform by changing the SourceObject of the subform to another subform. However...

I get an error when I try to run this. Can anyone let me know what the proper syntax is for this? Thanking you in advance. Dim strWhere as String strWhere = "[DrNumber] = '" & [cboField] & "' And [DRNUMBER] is not Null " nCount = DCount("[DRNUMBER", "FIREARMS", strWhere)

I have three tables (Main, Item, Suspect) that have the same key in each table, called DrNumber. I created a select query with an inner joins. As follows: SELECT DISTINCT MainTable.DrNumber, MainTable.OfficerLast, ItemTable.Item, ItemTable.LabAnalysis, SuspectTable.SuspectLast...

I have a form with edit fields. The blank fields I would like to change the background color to red. This is to indicate to the user these fields may be entered. So I have two issues: 1) is the table field blank 2) if it is blank, change form background color to red. How does this look in...

I have one form I would like to open from two different places. In one case I would like to open the form with some fields disabled, in another place I would like the form opened with all fields enabled. I hate to build a copy of the same form for this. Can I pass a parameter so that it may...

I have a form that contains multiple records. I can delete each entry successfully without any Access harrassment. However, when I select the last record and either hit the delete key or click on my delete record button focus remains on the required field and any attempts to go anywhere else...