Search results for query: *

I am planning on marketing an application via a paid download from my website. I have packaged my Access 2010 database and all is working great. I have coded protection for unauthorized distribution and use once someone has installed, but am trying to figure out a scheme to prevent somebody...

Thanks for replying vbajock :) I was fighting with this again today and discovered that the field containing the data I was querying against is a multi-value text field. Therefore, Access could execute the query but Word couldn't interpret it and had no data. I tried embedding the column in...

Mailmerge has been working until.... I have a query that is returning a dataset in Access but when I execute the query in the mailmerge function it's empty. I've checked the querydef in the function to see if it has been truncated but it's not. I can execute the query from the function and get...

Perfect!!! I figured it was something I was overlooking

I am having a major synapse lapse - I'm sure there's an easy fix for this..... I've got a simple pop-up form for contacts, but if the c_type field is "Tenant" then the c_broker field is required. I've put this in the OnClose event, but I can't figure out how to keep the form open after it...

I tried to do an update query, but this is a dynamic report and the criterion isn't static., i.e., catalog 1234 might have 60 rows (items) of different item numbers and catalog 9999 might have 10 items, so I needed a way to loop through the query without hardcoding anything. i.e., if I run the...

Sorry for being a VBA rookie - I am decidedly in over my head! I've looked for similar code to borrow and didn't see anything similar. Crosstab isn't suited and neither is concatenate. I’m trying to create a temp table from data that is in rows and I need to convert to columns so I can format...

All of my other MS apps (Word,Outlook,Excel) have 2 OpenType fonts, but I don't have them in Access. Is this because Access can't use them or do I need to reinstall something? Of this course, these are the only two fonts this client wants to use. If anyone has run into this before - I...

Never mind - I feel REALLY stupid! The first line of the memo field was a NL/CR so I didn't see the data until I expanded the field. Sorry! You've been a great help - this works exactly like I wanted it to. It even resolves my audits on related tables. Thanks again -

I've changed your code only to add site_key instead of FormName as my primary key for tblAudit. The new memo field is still not being updated, the others are. The Updates field is on a Tab named "Pg_Update" that is captioned "Audit Trail". I've checked all of my naming to make sure I don't...

A star for both! I implemented willir's suggestion, but I am still not getting the memo data to store in the Updates field - it shows up in the Updates control though. I'm going to try MichaelRed's module since I encountered trouble with audits on some relational tables. I think the single...

I'm probably overlooking the obvious - I'm using the MS AuditTrail() module and have changed it to explicitly reference a bound control on my form; [txtAudit]. I'm calling the module from the BeforeUpdate event on the form and it's working fine, but the data isn't being stored in the field. I...