I figured it out!
Thank you for the hints!
PaulaCM
Last Activity: Oct 14 '08, 09:03 PM
Joined: Apr 2 '08
Location:
-
Okay, how do I do that?
Most of the team use the form anyway.Leave a comment:
-
It's in a table that I have used to populate a form.
Thanks!Leave a comment:
-
Lock a column
Folks -
A lot of my distinguished colleagues use my (yes, MY) Access 2007 database. I have one column of information that is particularly important. Is there any way that I can "lock" a column so that only I can make changes to it?
The rest of the database is very user friendly and everyone uses it without a problem.
help!
thanks!
PS - if we're using code for... -
Okay. I'm slower than I thought.
would you mind explaining step by step how to incorporate your excellent code into my table?
thanks!Leave a comment:
-
Thanks everyone!
I'm definitely going to keep my primary key an auto number and try to impliment missinglinq's code. Although, i'm a little slow, not having done expressions of any kind before.
So, I'll be back if I can't figure out how to use your awesome code!
thank you again!Leave a comment:
-
Sorry, could you give me more step by step instructions? I don't understand how to do this. It sounds like it's simple, but I'm an access beginnger (it's 2007 btw, dont' know if that makes a difference).
thanks!...Leave a comment:
-
Select a STARTING Primary Key
Hello Again Byters (hmmm... that sounded better in my head!)!
Question on Primary Keys / Auto numbering.
I want to make sure that each record has its own individual ID (hence primary key) but, I just want to choose the starting point. So, instead of starting with record ID 1, I'd like to start with record ID 1024. (I'm replacing a paper system with an electronic one, but would like to keep going from where I left off).... -
thanks!
I founds a way simple way to do it by creating a button. I've set it up so that it prints only the individual record and defaults to pdf!
so, thanks, but yowza that code looks complicated. I am in no way that cool....
best,
PaulaLeave a comment:
-
Export an individual record in a form
Thanks in advance!
I have created a beautiful form that pulls all the right data from my table. (Hurrah!).
Now, I would like to be able to export each record (from the form) into its own pdf so that I can create and send invoices. I can pdf every record in the form using the Acrobat commands on my ribbon (obviously Access 2007). However, I haven't figured out how to pdf just one record.
is that possible?... -
Thanks for the help!! Guess I have a lot of updating to do.... and replica deleting...Leave a comment:
-
Master and Replica
Okay -
so, I made some design changes in my Master Document and when I tried to synch them with the replica it told me that I couldn't (because I made design changes).
I can't change the design of the replica, because it's not the master (in order to make them synch up).
I can't just create a new replica because (even though I told them not to!) other users in my office have used the replica instead of... -
I know that I'm being obtuse, but .... still not working....
Here's the code that I've used:
Private Sub Form_BeforeUpda te(Cancel As Integer)
Me.[Date Updated] = Date
End Sub
No updating of the date even when I save, exit, or move to another entry.
Thanks for your patience and your help (clearly, I'm a moron)Leave a comment:
-
I tried that!
I've tried saving the form, saving the record, moving off the record, everything that I can think of and now the date isn't updating!
I even found the datasource on the checkbox for my yes/no fields (thanks for the tip) and the source is the correct box.
so, I really don't know what I'm doing wrong...
here's what my code looks like:
Private Sub Date_Updated_Be foreUpdate(Canc el...Leave a comment:
-
Nico -
I'm sorry, but for some reason, this isn't working again. I do have some that updated, but now they aren't doing it.
Also, if i'm on one of the yes/no fields, I don't have any options under the data tab.
Sorry to be such a pain!Leave a comment:
-
Create a form based on a query
Is there a way to create a Form based on a Query?
Everyone in my database has a staff point person assigned to them. I've created a query for each person where they can find only their contacts. I'd like them to be able to use the forms to update the information, but not have to sift through the WHOLE databse to do it.
Make sense?
Thanks in advance for the help (and step by step instructions)!
... -
Thanks Nic!
It's working now. But, it only updates if I change something in one of my text fields, not if I click a yes/no tab.
Not a big deal, but it'd be good to have it update upon either.
Does that make sense?Leave a comment:
-
Nic -
Hmmm... this doesn't seem to be working for me. Firstly, I'd like it to update the date only after I've updated something. Secondly, it just didn't work :(
thanks for taking the time to help (again)!
best,...Leave a comment:
-
Auto Update a Date
I am trying to create a field in my Access 2007 form where, when you modify anything in the form it updates the date.
In other words, I have a "Date Update" field that I need to automatically update, only when something is modified on the form.
I'm a novice, so please explain in step by step terms!
Thank you!!!
No activity results to display
Leave a comment: