Search results

I did not know that an editable table can be based on a query record source. I wanted to stay away from creating a subform to edit tblAssignment because I rely on list boxes to choose subform records for editing. This causes the user to interrupt the flow of work to navigate to the next...

vba, The data I would like to filter by is not in the record source. Let me illustrate the issue: tblCourse: fldCourseID (Primary Key) fldCoach tblAssignment: ("Sub-Table" to tblCourse) fldAssignmentID (Primary Key) fldCourseID (Foreign Key) The form is for editing tblAssignment records. I...

I would like to create a continuous form that is filtered on data related to a foreign key. The easiest way to explain my issue is to ask if there is a way to filter on a DLookup field. Thank you for the help.

I have multiple cases that includes multiple "true" results. I am confused about the best method to proceed with my query SQL. Should I use nested IIf's or does Jet SQL support cases? What is the correct syntax for multiple "true" results? There are three cases: Condition A, Condition B...

Thank you. The @ symbol was in the format property of the problem fields at table level. I will test it at work tomorrow, but I'm sure that was it. Thanks again for your help.

Bound combo boxes that I built in A2007 are not displaying on machines running A2003. I used the 2002-2003 file format though, which was the default new files. The bound values are being posted to the table. 7 of 9 combo boxes are not displaying values. The application has two separate...

Great. So I kept the =nz(DMax(field)+1 as the key default, and in addition I added it to the beforeUpdate event. Looks like it is working. Thanks again.

Thanks. I have tried this and the form opens to record #0 which also creates integrity issues. How do I provide a "new" record in the meantime? Is there a way to duplicate the autonumber behavior of using a generic record until update?

I am using A2003. I have an single-Form that uses =nz(DMax(field),0)+1 for the key's default value. The key is set for no-duplicates. Multiple users are stumbling on each other when concurrently using the form. At this point, it's easier just to tell my small group to not enter the...

I tried it with RecordSet because I could not get RecordsetClone to work. RecordSet gave me essentially the same count as =Count(*) - a total count of records in the report. Will RecordSetClone help me return a count differently than RecordSet would for records up to the OnFormat record...

I have an A2007 report that includes 8 tickets per page. Each ticket represents a query record. I would like to show which "record of total records" a specific ticket represents, much like "=[Page] & " of " & [Pages]". The page function returns 1 of 3 when there are 24 tickets on 3 pages. I...

Thank you for the good feedback. I just experienced the problem on my computer. I first experienced it after substituting DCount. I then experienced it in my backup file that still had ELookUp. Microsoft DAO 3.6 Object Library is referenced. The field is indexed. I wanted to share one more...

This is the E-Lookup module code (created by Allen Browne). Thanks again.

I am using A2003. The below VBA searches for a record. If the record is not fourd the VBA opens another form using an OpenArg. The operation works well on my computer. But it locks-up 10% of the time on user 2's computer, and 95% on user 3's computer. I have changed the DB's open mode to...

I've been excluding the possibility of operator error because the problem is systematic - only occurring with DoCmd.OutputTo queries. The only code associated with those queries is DoCmd.OutputTo acOutputQuery VBA function. No macros. The SQL includes simple SELECTs and LEFT JOINs.

Husky, Thanks for making me go through that process. It caused me to notice the records were being transferred to a new tab. This must have started when I changed the name of the query a while back. Namliam was right. Nothing broke. Thanks for the support.

The query shows all relevant records. Thanks.

My "DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9" operation has stopped exporting records. I do not receive errors like the path cannot be found, etc. The operation seems to be successful until I open the excel file to find no records. I am using A2003 and E2003. However...

I am having the same problem in two separate databases. The entire SQL in queries that are used for "DoCmd.OutputTo acOutputQuery" operations gets sporadically deleted. I can export multiple times with no problems and come back after a couple weeks to find no SQL. I tested compact/repair as...

I did have this function in a WHERE condition. How is the IIF function utilized to define criteria if not in a WHERE condition?