Search results

Found partial answer here http://stackoverflow.com/questions/393381/recommendations-on-using-sql-server-guid-from-ms-access When you try to get a GUID value from a control in a form (usually as the linked field in a combobox), you'll get '?????'but no value. You have to refer to the field...

I tried adding a button using the wizard to see if that would work. Linked the PK field, however now I get a Parameter Pop up with asian characters as the description?!?

Even when I add a hidden textbox to store the value from the query - the value is loaded into the textbox right, but doesn't change that I receive "????????" when referencing Me.field

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

Ended up having to flip it back into a GUID declared variable and again to String (non jet), but ya put me on the right track. Thanks

That looks good, thought I might need the GUID functions. Out of curiousity, is the () for the byte variable required? What does it do?

Nope. I think it must have something to do with rid_Database being a GUID

Yes Yes

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

that was it... cheers!

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

No no, it was meant to exclude rows where category = 4 and issue = 12. Found a solution. Just used WHERE NOT(category = 4 and issue = 12). Still don't understand why first didn't work.

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

Ok, figured out a portion of my problem. Due to the way the form needs to function, all the combo boxes had to be Unbound. I obviously needed to set a Control Source if I want to populate the boxes. So I've fixed that, it will display the options selected in the various combo boxes.. Now to...

I don't understand the question. The form is for an individual record so without a filter it will just open blank.

There is no one to many relationship between the main form and subform. The portion in the subform is fairly complex, with numerous fields. The main form just contains 6 or 7 basic fields. I'm trying to open the form from a Click event on another form (launchpad) with the filter applied, so it...

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

For anyone wondering, I found the cause of the error message. Has to do with Macro Security Levels/Sandbox mode. Looks like RecordsetClone is on the "flagged" list. Here's where I initially found the answer http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1168248&SiteID=17 and here is...

I don't see any "MISSING" references in your database. The following are checked; - Visual Basic for Applications - Microsoft Access 11.0 Object Library - OLE Automation - Microsoft ActiveX Data Objects 2.1 Library. Would just like to note the error is actually appearing in your example...

That looks good Maurice. I am getting an error when i click a button "The object doesn't contain the Automation object "RecordsetClone" Is it just the macro which handles everything? I can't find anything to do with the RecordsetClone anywhere (no modules, not in form code) What/Where is the...