Recent content by natsirtm

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.