Clamato
Last Activity: Sep 18 '08, 08:32 PM
Joined: Feb 6 '08
Location:
-
Ahhh, I didn't understand. Thanks so much! -
Thanks for the help again, unfortunately I'm not able to implement any outside tools without approval, this is something that definetely wouldn't be approved. Thank you though for the help, I'll wait to see if anyone else has any suggestions, otherwise having users manually refresh their list should be sufficient.Leave a comment:
-
Thanks for the reply puppy.
Well, I probably should have shared this piece of information, the form is used on a network by multiple users at the same time. The .mdb that holds the forms is copied to their local drive and opened from there, records updated via linked tables to the network drive, so it seems that the after update only works on their machine when they make a change, it doesn't reflect to anyone elses. Is there a...Leave a comment:
-
When a duplicate record is added it also seems to stop the timer for some reason. I'll look into the properties of the On Timer eventLeave a comment:
-
Thanks again for the help. I have another question....I have a refresh command button on the form that requeries the listbox to show updated records if they're added by another user. I'm playing with the ontimer event of the form to Me.Refresh every 5 seconds. This seems to work, however the form becomes fairly choppy because of the refreshes. Is there a better way for a listbox to be in sync with the table with no work on the users part?Leave a comment:
-
Beautiful. Thank you SO much!Leave a comment:
-
Trouble inserting records
Good Morning,
I'm working with a form that basically add's a users windows logon ID, first name, and last name to a table. A list box on this form is then requeried once added displaying the names in this table. I'm ultimately trying to make it so the user can't add their information twice in this table. Well, you would think just making their ID the PK in the table would work, however I'm running into an issue with this.
... -
Beautiful, ok I think it's finally working. I didn't realize this, but I found in the wizard the add new record button. So I just used the code from that and added it to my existing button that brings up the dialog box. And with the OnDirty event everything gets saved! Man, after looking back it seemed like the solution was easy, just took me a bit to figure it out.
Thanks so much for everything again Scott, I appreciate it!Leave a comment:
-
Thanks Scott,
I agree about the query, I thought that may be the easiest way to update the records, either way you're right, they're entering the data to input. The on dirty event seems to work. However, this adds the record once the form is closed right? Or does it add the record when a change in the form occurs? I can't seem to tell. They usually will be adding one record at a time, but I would like to be able to add them without...Leave a comment:
-
Ok, I see. Well, I don't really think I'd like to have users update records like that. I know it's the simplest way, but I don't think the users that use this will be able to understand how this works. I'm trying to stay more object oriented like the rest of the portions of the form, so I'd like to remain using a button to update records. I'll keep searching and looking around. Thanks again...Leave a comment:
-
I've tried this in the event for the button, but am getting syntax errors. I saw this on another forum, they were trying to accomplish the same thing as I, feel free to laugh at me if this is rediculously wrong, Access is soo new to me :)
Code:Private Sub btn_load_Click() CurrentDb.Execute "Insert into tbl_doc (client_ssn) Values('" & Me.txt_TIN& "');" End SubLeave a comment:
-
Hey Scott,
I thought it was working, but boy was I wrong. I'm not sure what's going on, but when the append query runs it takes whatever records are in the table and duplicates them. So it took the first one, then when I tried again from the form it updated it twice, then four times, then 8, 16 and so on...... From a query standpoint..... if I had a textbox in a form and I wanted to add the text that's input in that box to a new record...Leave a comment:
-
Ok, i think I got it working! I'm going to work out any bugs, if I have any other questions I'll come back. Thanks so much again!Leave a comment:
-
Thank you Scott,
Well, I'm still having trouble with this. It appears the other person that had this before me somehow disabled the ability to move through records from the form. Any records that needed to be input are done through code directly and any records that need to be viewed run from query's.
I've bound the text boxes that I need to input into the table, and have an append query that runs once I click the...Leave a comment:
-
Thanks Scott,
I am using access2000, I wonder if that's why it may not be working for you. The dialog box seems to be working perfect for me at least. :/ You stated earlier there is a way to avoid the "confirmati on" prompt when an append query is run. Is there a flag I can input, or how would I accomplish tha?. Also, from a SQL statement standpoint, how would I create a statement that would append a string that was input...Leave a comment:
-
Holy crap! Wow, I feel like an idiot. I should have realized that. DUH!...Leave a comment:
-
Thanks Scott,
Ok, I understand the Record Source and Control Source now, I've made that change to my form and the controls I'd like to use.
As for the code that's being used for the dialog box, I used this from another source attempting to obtain the same goal as I. It's listed below
Button on the form:
...Code:Private Sub btn_load_Click() Me!Txt_loc = LaunchCD(Me)
Leave a comment:
-
Thanks Scott,
I definetely understand the concept, it's just putting it into code that's the problem.
I attempted to create an append query, but was running into trouble having the query take the string from the certain text box and place into the appropriate column in the table. I would also like the table update to not really involve the user except for them to perform the action, with the query it would ask if...Leave a comment:
-
Thanks again Scott,
I think I understand the code for the dialog box, I currently have it where the selected file displays the path in the text file like we discussed earlier, if the code you included may be a more streamline way to accomplish this I'll definetely make that change.
The main issue I was having was actually inputing and formating that information into a table. I don't have any experience with Access...Leave a comment:
-
Hi Scott,
No, there honestly isn't any reason why I made the path the primary key. I guess I was thinking I wanted that to be unique to keep people from submitting multiple records. Before, I didn't have a primary key at all, an autonumber would work just fine. I will use that instead. :)
I'm hiding the path in a hidden text box only so the form looks more streamline to the users. I'm ultimately trying to get the path into...Leave a comment:
No activity results to display
Leave a comment: