Search results

I have a continuous form that I use as a launchpad to open individual records. However it doesn't open the right record, and troubleshooting shows that instead of the records primary key, it's giving me "????????". I am using replication id's for the PK. Any ideas? TIA

Can't for the life of me figure out why this won't work. Simple DLookup ? DLookup("rid_Database", "tblDatabases", "[sDatabaseShortForm]='3CONP'")rid_Database is valid field in table tblDatabases 3CONP is a valid entry within the field sDatabaseShortForm all i get is ????????

First here is my code Option Compare Database Sub tmatch() ' Set Database Dim db As DAO.Database Set db = CurrentDb ' Get unique secondaries without matching record in list with agreements Dim strSql1 As String strSql1 = "SELECT...

I'm trying to get this query to return all records except those with category: 4 AND issue: 12 Instead I'm always getting ZERO category: 4 and ZERO issue: 12 Should not the parenthesis force this to be taken as a single "WHERE"? SELECT ASSIGNED_TO, COMPLAINT_NUM, DATE_RESOLVED, CATEGORY...

I have a form which contains a subform with tabs. I've written a query which contains all the fields on both the main form and subform. I'm using this query as the recordsource for both the main form and subform. I've been trying to apply a filter based on the PK ("ID") but am unable to get...

I would like to create some command buttons to making scrolling through a long continuous form simpler. As anchor tags in HTML, listing each letter of the alphabet and when clicked would scroll the form down to the first record beginning with that letter. Been googling but can't seem to find...

If i setfocus to a subform, does Me refer to the focused subform, or does it still refer to the main form? eg. If Me.Dirty Then 'Here, Me refers to the form Me.Scores.SetFocus If Me.Dirty Then ' Here, does Me refer to the form or subform? DoCmd.DoMenuItem acFormBar, acEditMenu...

A bit of background. Trying to automate production of a report with subreport. I have a single date parameter selected from a form for the report's queries. I want to use the same date as the parameter for the subreports' query. The report queries to which the parameter applies are action...

I've been playing around with storing date values as numbers (Integer/Long) I'm interested in coding something to kind of "automate" it. My thought was to use the field description to keep track of fields which should be considered dates, and then automating the storage as Integer and the...

I have a temporary table with all text fields for importing data to a normalized table. In order to import I need to prep the data by pulling the numeric values of "lookup" type fields (nb. not actually using MS Access lookups) My prep query is producing 9 more records than there is rows in...

Hey folks, I'll try to be succinct. I have a short module using the transferspreadsheet command importing an excel worksheet into a table. (blahblah_import). Before I can append those records to the permanent table (blahblah) I need to pull the correct # values from various lookup tables. I...