Recent content by DebSabre

Reply to KenHigg I am using the VBA to eliminate records with duplicate dates,times,destinations,.... I have a one to many join on two tables, but in this instance I don't want to see the duplicates. So I am copying 23 fields from one table to another. I thought there may be something more...

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...

Pat, Thanks for the suggestions. I will be implementing them. I value your knowledge and I'm impressed with the responses and timing of responses on this forum. You are providing an valuable service to many. Keep it up!!! DebSabre

Rob, Attached is my db. The form is frmGrievanceMaster. Let me know. Thanks.

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 just figured out what was wrong!!! Thanks anyway. nCount = DCount("[DRNUMBER]", "FIREARMS", strWhere) didn't have the closing ]

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 am using Access 97. How will your suggestion work for a continous form?

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...

Thanks Thanks, that's what I needed.

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...