Search results

Hi All, I have some comboboxes setup to build a sql statement and have a subform to be populated with this statement as the rowsource. This works great. I want to give the user, on one field, the ability to use either the combobox or specify a string of text to search for. The combobox is...

Hi All, I am looking at taking over development of a database and I encountered code for "DoCmd.DoMenuItem acformbar, acRecordsMenu, 5, , acMenuVer70". I don't use this as I use the DoCmd.RunCommand approach and I am unfamiliar with what Command "5" is. Since this comes from a Macro Command...

Hi All, I am trying to setup an interface for a user to import a list of items into the database. What I'd like to do is allow them to pick the file to import and then import that file, creating the records in the related tables as well. The trouble is I don't have the ID from the main table...

Hi All, I have a query that merges data from two sources and creates a spread of data for use in a report. This all functions and the report works great. What I want to do now is add subtotals to the report. However, when I go down to the second grouping, I need to sum a value only once...

Hi All, Obviously I cannot use vba to update a record by using a simple me.control = blah because it will update all of the records. However, is there a way to grab the PK of the record so that I could use it to run an update query? I just want to be sure I am grabbing the PK from the...

Hi All, I have a report that works flawlessly when a user runs it and enters the specific job number they want the report on. What I'd like to do now is allow the user to run a batch of these reports by Client. (Clients own the Jobs). In order to do this, I created a form in which the user...

Hi All, I haven't been able to figure out how to call the selected records in an access continous form so I may create a new recordset from just those records. Here is what I'd like to do: 1. Have a user be able to select multiple records using the built in access record selector. 2. Create...

I am trying to figure out a way to make a copy of some of my tables once a week so that I can run a report that idenitfies what has changed since the prior week. I figure I will create the tables and then create code to update existing data and append new records. I would also like this to be...

Hi All, This has been discussed in an older thread, but I still wasn't able to get this resolved. I was informed to start a new thread and go into more detail so here goes: 1. I want my form to only add new records. 2. Like it should, when you start typing information in one of the fields...

I have a query in which I want to pull the latest entry from another query. No matter how I have sliced it, it returns the latest for all records regardless of the mrid. Here is the code... (Select Top 1 Expr1 FROM NOTEMERGE WHERE NOTEMERGE.MRID = [MRID]) The NOTEMERGE query grabs all of...

I am trying to create a form that will add a record to the bound table and also to the related tables. I also would like to prevent the form from updating until the user clicks the add button. This will trigger the record save and then (ideally) the creation of a record in 3 other tables. I...

Hi All, Here is what I am trying to do. I have a query that functions and shows all the data I want minus 2 fields which I want to show more than one record from. Here is a simplified version: Job PO Desc Items Notes 1 6 test 12-1 blah 12-3 blah2 10-5 blah3 It is possible to have more...

I have a function to open a form based on linked fields. I don't want a user to be able to open 2 versions let alone 16 of the same record or multiple versions for different records. I would like to build in the following functionality: 1. Check if form (MRSTAT) is open If it is, Cancel...

I have a database where I store notes in a separate table where it stamps the username and date and time of the note automatically. I know how to use SQL to select the latest date, but I want to know how to make the field automatically requery when a report is run. It is easy to do on the...