Search results

Gosh!! How silly of me. Yes, I have enabled macros and code....works fine now. Didn't even consider that - I errounously left it disabled when I opened the database. Thanks, Bob. :)

I just tried again.... using access 2007. Thanks for replying....still baffled tho.

I thought of this too.... I took away the exit behaviour just to try to make the button 'click'.... I guess my question is this: How the heck do you apply a specialeffect property to a label?? lol...I cannot seem to manage it via macros, expressions or code.....!! I know I want to format as...

I am trying to apply the following behaviour to a label formatted as a Raised Label (Label1) in order to make it mimic a button: I have a label with the 'on click' macro set to exit the form. I want to create a bit of code as follows: On Mouse Down: - I click event the button to choose the...

Thank you both for your thoughtful responses. David: This is the first time I have written something as complex as this for a group of users....yes, the master copy was sitting un-split on the server, each user utilizing a shortcut pointing to it....the lead user would 'back up' by copying and...

I know I posted a similar thread in General: no one has read it and I think I need an expert. Hopefully will find one here. Totally confused. I have a database that is on a server, populated with a bunch of data and forms. There is a security file associated with it that has 10 different...

All my data has completely disappeared in the main and back up db! What happened? I have a database that is on a server, populated with a bunch of data. There is a security file associated with it that has 10 different logons, each with special accesses, as well as an administrator password...

Have no idea what happened. I have a form. Assigned a little code to lock certain fields on certain criteria. The form stopped allowing any and all edits. Don't understand how the code locked the entire form, it was very specific to just certain fields but, nonetheless, I deleted it all...

Bill - Worked liked a charm!! (Thank you too, John, I did not enter your solution tho...because Bill's seemed to do the trick. However, for some reason, I found that only entering the second condition (oncurrent) was actually necessary.... Perhaps something I've failed to explain, but, it was...

I have a field for "projected budget" (is "0" prior to entry) and "final completion date" (is null prior to entry and is date format after update) that I would like to have editable only once. The condition I'm envisioning is that the field is updatable IF the value is Null (or zero, or...

I have a workgroup set up with users. I have a form for updating projects which contains records for all users. One of the fields is "Project complete"? I want this record to be editable/updatable only for those that the current user is the project owner of. I want the field to be 'locked'...

I'm open to different suggestions... Is there a simple way to make a database web accessible? To be able to add data, run reports, run forms, etc? How difficult is it? Thanks for any opinions!

Okay. Well, I've seen a couple of good answers here...so I will add a couple of specifics to narrow it down. I am thinking to charge hourly. Will be a small inventory mgt dbase for about 100 pallet spots, transfers, and report features. It will be 2 or 3 master tables, a few queries and a few...

Good Morning; I posted here because I figured this was where I would find the most professionals. I have over a decade of experience in writing databases & related reports (no VBA, all macros, forms & queries). I've been offered a 'contract' of sorts to write a very simple inventory mgt...

Thanks, Steve! Worked like a charm! :D (gratefully clapping my hands & smiling). Boss is gonna think I'm a genius. Nice.

Here's one I cannot get my head around. I have a list of order numbers to follow up. I want to pull related email records to the list of order numbers. Each email record consists of a long field of text, where the order number may or may not be. Therefore: I want a query that will display...

Thank you!!! CraigDolphin/Rural Guy Thanks so much to you both for solving my dilemma so fast! I found both worked as you have indicated. I went with CragDolphins' bit of code and it worked like a charm! :D

Hello, all; I think this is probably a simple solution for some of you. I have a database containing records for which I need to set dates to follow up on. I would like to ensure that the date that is entered is a business day (So that when I run my follow up report for the day - I don't...

A fast & dirty way to do this, AND get the "|" symbols you're after: Create a make table query. (assuming you already know how). create a new output field using the expression: New field=[Name]&"|"&[Description]&"|"&[URL]&"|" etc. Zap. Now, simply open your new table & copy & paste your...

Sometimes, cheating and doing things the easy way is the fastest (if not the fanciest) solution. Anytime I have trouble importing a table, I simply go back to my original file - format it identically (field order/field type) to the destination table and copy/paste it in. I assume you are trying...