Search results

When you google thing kind of thing you end up on stackoverflow learning about 6NF, I've had to take over databases designed like that, they make sense, however starting from scratch with just the tables is fairly tricky when you have more tables with 3 or 4 columns of ID's than you have tables...

lovely thank you, that worked a treat, I wondered if a With was the way but I didn't quite apply it to get the docmd working how you described :)

As part of a deployment tool I want to rename autoexec1 to Autoexec to "enable" a database for deployment, In VBA I've got a "Save and Publish as ACCDE" working and "compact and repair", I just need to rename this macro and I'm sorted, Set db2e = OpenDatabase(CurrentProject.Path &...

Yea I know what you mean, each record is unique but it's actually an either A or B unique on two columns which isn't an option in SQL I dont think

yup, I was hoping there was an easy workaround to get only the unique values both sides

Ahh, I see how that works now, your ID's are sequencial so 3 and "name3" both share ID 3, because I've got data from two different tables filtered by Set=ID6, with their own ID's of e.g. 16, 17, 18 from table 1 and 35, 36 from table 2 I can't join the way you do on ID=ID, I'll add a unique ID...

Hi Pat, I only wanted to join them for display reasons not data relation reasons, cheers,

That's odd, I don't get the same result using an outer join, I get the 6 records, Or, well, 15 records because I have 5 records in Table1 and 3 records in Table2 but I didn't want to make my post too long!

I have data in two tables like: ID ParentID Value 16 ID6 1 17 ID6 2 18 ID6 3 and ID ParentID Code 35 ID6 A 36 ID6 B and I want the report to show this in the detail: ParentID Value Code ID6 1 A ID6 2 B ID6 3 instead of how a query would normally give: (without...

How exactly do you mean proper error handling? what would that look like? I feel like for an automated app that "automatically retry" is about the best, along with "restart from the beginning"

I'm running the query from VBA, literally using the green play button at the moment for testing, later it'll be fired by a form timer event or directly from AutoExec possibly, I know better error handling is normally the case but these databases I'm experimenting with will be running...

It's actually an Update Query that throws the error despite the error handle statement and there's not a "No Locks" option on an update query, This code needs to wait until it can run, it shouldn't escape

yes the front ends are on users local drives and back end is on server shared drive

Thanks, I've checked the first point and I can only see an option in "Client Settings" for default open mode and that's set to Shared :) Looking at the queries Properties they're all set to "Edited Record" I've just changed Query1 which was a select query to Edited Records and the issue persists

I have Page level locking on if that makes any difference to the below I'm trying to make multiple "worker" databases process data in a table (current in an ACCDB on a server, to be moved to SQL server at some point) there's too much data for 1 to process in a timely manner (as real-time as...

That would be ok but you can get significant drift if a run is late etc and a good chunk of these things need to be sent of out for the start of the work day then as close to 12:00 as possible oh and I've solved my 7 day issue with some binary: clbincomp is just a vba "and" to do a bitwise...

Yep that's pretty much what I have going on now, it's running on a dedicated PC so that's ok Currently I'm trying to figure out how to implement similar in a query without 100s of criteria lines, i've got a boolean for each day but that's instantly resulted in 7 criteria, lol

I have about 150 different reports on 3 different frequencies currently but the way I did it back in 2011 is to manually set the IF's of like, "Day" between 2-6 "hour" between 8-17 every "half hour", or "first of the month" or "Monday 8-17", problem is where people want it on a tuesday I have to...

Yea he does, about basically checking datefield1 > datefield2, that's what I currently do to check if a report has been run before emailing it as an attachment, However it's the part where in Task Scheduler, where you set the future schedule, that I want to re-create, so initially both date...

Thanks for taking the time Adam, sounds like you're fairly flat out! I've found a post about "untick a check box after 48 hours" if that's the one you meant? I sort of know where to start but some thought and trial and error is required before I make it a thing, just checking i'm not...