Search results

I'm not really sure. I was thinking of having the main form record in a "header section" at the top, and related child records in rows below it. Like what a form/subform displays in Access. But for now, I'm just dumping the raw non-deduplicated data into Excel. Thanks

Thx!

Do you use CopyFromRecordset from the Access side or from Excel? Do you have an example? Thx

So I have the main form with the one record, and the subform with related records. I want to export the main form record as a header in Excel, and the subform records as rows below that. Anyone know how to do that or have an example? Thx

Anyone know if this is possible? Thx

I realize that but what about once the add-in is loaded? Can the add-in's ribbon be loaded once the add-in is loaded? I don't understand this. My ribbon xml has this Expression: =msgbox("Add-in loaded"). But even though the add-in is loaded, its ribbon still is not displaying. I was...

In the following add-in, if you open it up stand-alone, you can see the ribbon it contains. But if you install it, the ribbon doesn't display even after the add-in is loaded. Is there a way to load the ribbon dynamically in VBA when it's installed? Thx

No pass-throughs. There's just append queries only, and they all have to run. So I'm not worried about running anything that shouldn't be run. So you're saying leave out DoEvents? That would probably speed up the process but I don't want any query to not run. I'm also wondering if using ADO...

I'm running a bunch of saved append queries in a loop. The queries add records to linked SQL tables from local Access tables. Using DoEvents makes it take forever. Is there a better way? Is using StillExecuting the preferred way? Here's what I have so far. Thx On Error GoTo ErrHandler Dim...

This is what I'm leaning towards: Although I like: Thanks all

Further info: I created the field in an existing table. It appears Access sets the existing row values for the field to 0, even though I specified a default of Null. So I have to go and set all the values to Null to get that default?

Please explain: 0 would be No, no?

As I said, they have to make choice. The default should be Null (they haven't made a choice yet).

I'm creating a new Yes/No/Null field in a table. Null means unchosen. When the user leaves the form that has the field, they have to make a choice of Yes or No. What's the proper way to set this up? I don't think I want a rule in the table as I want to handle that in the form. Here's my...

I know about that, I was was wondering if there might be a way to do it in code. I'm particularly interested in links. So if someone links to the db, a way to detect that even if they don't open the linked table.

Does anyone know a way to detect whether an incoming connection is made to an Access db, or if a someone links to it? Thanks

I agree that it's a good price for all it does, and FMS has a nice licensing model. In my case it's not about cost but the approved software acquisition channels my company uses. I've recommended other FMS products to them but so far no dice.

I would love to have that but my boss won't go for it (so far).

I agree but until users I'm supporting uninstall the older version, I have to support them with what they have.

That's just what I've found. You would think that Open With and version specific shortcuts would work, but in some cases, no :(