Recent content by usmc-ratman

spikepl: If the remarks were part of the same table as the main form, that would work - however since the remarks table is a separate relational table one to many, that text box won't have any value unless I can figure out the expression for the "control source" that can check the remarks table...

Ranman256, thank you for replying, however I understand that the button may not be able to actually have a different color by default - just didn't know if it could be applied using code - and if that was not possible to make the button background transparent with another control (i.e. an...

Using Access 2007 • I have a main form (continuous form named 2015CL) & one of the controls on this form is a button (named btn_opn_remarks) that is located in the details section of the form - so there is actually a button visible on each row of each record. When the user clicks the remarks...

Hey all - just posting a quick update to the thread. The suggestion by MStef is working great, I will add this to my arsenal. However, and unfortunately, the whole database has been corrupted so badly that I am just going to have to start back from scratch, and make a completely new db. I...

HiTechCoach: Thanks for the heads-up... I will study the information. For the time being I'm going to try the code behind the form by MStef, and see if that gets me through a full day without getting IM's that they are getting ready to shoot their computers.... :confused: Will post back the...

MStef - Looks like this will work, I will put this solution into the database tonight and see what happens through the day tomorrow. If they don't IM me, then I'll know that your solution was as good as GOLD. I had a throught that is similar to your solution, just not as magical :), i thought...

MStef: Will download and take a look at it, then post back... Thank you very much, JR

HiTechCoach - Thanks for responding... The query "behind" the subforms are all just simple queries. By that I mean that I created a query for the table "billing", and then set that as the record source for the subform "billinginfo". Then ran the subform "wizard" and told it to display...

Need assistance quickly.... please Have a main table with client personal information (name, dob, address, etc), then 5 additional tables (file notes, charting, billing, etc) that are linked to that main client table. The main table (named "clients") has a PK set that is autonumber, no...

[grab a drink and get comfortable, may be a bumpy ride :D ] All systems using WinXp SP3, database built & maintained with Access 2k, some access 2003 systems are using it as well. The database is split (FE/BE), the BE residing on a 1TB server, with a total of 13 users on an office network, each...

hey guys - sorry forgot to close this thread out as solved / closed....

husky, I think your probably right, the 'DoCmd.RunCommand acCmdSaveRecord' line may not be needed, as the record will be saved when they move out of that record. I'm just having a problem limiting the 'undo' function to just that field that is protected. I only have the two fields that need to...

On a form, need assistance in fixing a vb script msgbox problem. I have placed the code listed below to verify that the user wants to change an existing value in a field. The code below works fine, UNLESS the user has made other changes on the form prior to changing the checked fields There are...

frankbutcher - I had a similar task to yours. The post may give you something to work from, to get where you want to go, or someone more apt at script may be able to take the script and build on it. The post is here http://www.access-programmers.co.uk/forums/showthread.php?t=116615 on this...

Moniker - I tried this last night, but it didn't seem to work, I edited my initial question above to include the structure of the clientList table fields that I need. Can you show me the SQL structure your talking about using the fields outlined in my post.... Thank you, JR