Search results

Dave, that seems to be the case. I had my app db and my library db in C:\FolderX. I created the reference in my app db. I then moved both files to D:\FolderY. Without doing anything else I ran the app db and it worked fine - no broken references! I have also now worked out that if you need to...

Hi, I have an Access 2010 library accde database of functions and tools which I want to distribute to a team of developers, so that they can add a reference to the accde in their applications and call the functions within. One of the functions opens an unbound form, also contained in the...

Smig, that's brilliant. I should have tried this first, but Microsoft's documentation seems to imply that it doesn't look there when trying to fix the reference. I just checked with what Smig said Gemma, and it looks like if you drop the file in the same folder as the application db, then...

Hi, Can someone tell me the best way to achieve this. I have an Access 2007/2010 database containing a library of functions which I want to be able to distribute to a team of developers to use. It is important that they can call the functions in the database from within their own applications...

Hi, Can anyone tell me, in Access 2010, if you have a form with a subform in datasheet view, and you move the focus away from the subform, how can you tell which record(s) on the subform are selected? When the subform has the focus, the selected row is shown with a blue/grey tint. But as soon...

Hi Dave, Unfortunately, in both cases, there is a big difference between the variable not being set (in which case the user needs to be made aware and prompted for some action) and the variable set as NO (in which case he/she doesn't.) It's also worth reading the link above, posted by PBaldy...

Hi Dave, Unfortunately I think I do. One of the variables stores whether a local piece of hardware (which can be easily disconnected) has been detected, and another stores whether or not the user has selected for the program to communicate with an external system, which may or may not be...

Thanks Paul. I just had the feeling I was missing something stupid. Thanks also for the link to Allen Browne's article - anyone else following this thread, it is worth a read - I had never realised the severe implications for outer join queries!

Hi, I have an Access 2010 db which has a load of global variables of type Boolean. The values are different for each machine the database is stored on, so I have a linked table to a separate Access mdb. On startup the database opens the linked table and assigns values to each variable. However...

Hi Burrina, apologies for taking so long to reply to this. Yes, I can always use IsLoaded to detect the form and re-maximise it, but the point is, it shouldnt be necessary, and having forms continually restore and maximise makes for a clunky user experience. Anyone else ever experienced this...

I have the same problem. Did anyone ever find a solution to this?

Hi, I am using Access 2010, but this is a problem which I have noticed going all the way back to Access95. I have a form (lets call it frm1) which opens maximised. A command button opens a second frm2, also maximised. If I close frm2, frm1 stays maximised. All good. But I have a 3rd dialog...

Guess you are right vbaInet. Thanks for looking. Another example of Microsoft removing something that was genuinely usefull, in the name of "progress"!

I don't have a layout set for the controls, because I dont necessarily want Access to align them all up for me. They could be distributed anywhere over my form. 1. Yes 2. Yes

Hi VbaInet, This was on a form set to Single Form mode. You can use the alignment tools when the text boxes are all in a row, or column. But sometimes you want to just make sure that different text boxes, not aligned, have the same offset to their respected attached labels. Does that make sense?

Hi, In previous versions of Access, certainly up to 2003, if you used the Format Painter to copy the format of a control to another, if those controls had associated labels then the format - and more importantly positioning of the label relative to the control - were also copied over. So for...

Thanks guys. Reassuring to know I am heading in the right direction. Some really interesting an useful snippets here! Thanks Galaxiom. The only reason I am not using a Boolean is because I need to differentiate between the variable not being set and the variable being set to False. Boolean...

Hi, I have an application where several different procedures are run repeatedly every xx seconds to get live updates from a server (different procedures depending which form the user currently has open.) Within each procedure, a separate single procedure is called only if a stored boolean...

Thanks Namliam - excellent idea. I should have thought of that myself!

Hi, I have an Access 2010 application running on Win 7 Pro which connects to a Back End SQL Server database. I am trying to get Access to synchronise the client pc system date & time with the Sql server date and time. Please note, the date/time does not necessarily have to be correct, it just...