JReneau35
Last Activity: Jul 26 '07, 06:59 PM
Joined: Oct 26 '06
Location:
-
Loop Statement to compare two tables
I am trying to run a loop statement that compares two tables. We will call them TableA & TableB and pks of LastNameA (tableA) and LastNameB (tableB). TableA is a table that was created some time ago. I want to do a loop that compares the data in TableA to TableB, if it finds that the date for tableA is longer ago than the date for TableB, I want it to update the day for TableA to the date in tableB. Also if the loop finds that there is no... -
Thanks for the reply. I guess I wrote my question wrong. I need this stored procedure to search a table for any names that it finds to be the same, not just a specific one, and replace the timestamp with a new timestamp.... -
If exists update, if it doesn't exist create
What I am looking for is a table that has two columns we'll say FName and Timestamp. What I want to do is to see if that name exists in my records. If it does I want to update it with a new timestamp. If it does not I want to create a new record in my table. This is going to be a check from vb 6.0 that is running continuously, so it will run the stored procedure to look for Redundancy in the FName column, if it finds it I want it to update the... -
Will this function automatically change with each month. So I don't have to plug in the month everytime it changes....Leave a comment:
-
Compare timestamps then delete
What I am trying to do is create a stored procedure that compares a the current datetime to a datetime field already added to a table. I also want it to compare the two and if the old data that is collected in the table is over 6 months old I want it deleted.
Someone please help -
Backing Up Database using code
I am trying to find information on how to backup a database by simply clicking a button on a form. When the button is clicked a message box pops up asking the user where the backup should be placed and what it should be named. Any help on this subject would be very benefical to me.
Thank you in advanced,
Justin -
Yeah I figured as much. Thanks for your help.Leave a comment:
-
Deploy MS Access without access on machine
I don't even know if this is possible, but I have written an MS Access application and now I am trying to give my fellow employees access to. The problem is that not everyone has MS Acess currently installed on their machines.
My question: is it possible to bundle it some way and have it work on each of their machines without installing the software? Also can I still update the information and have the updates shown on each of... -
Show only one of each application number w/o primary key function
I have a table that has multiple item numbers under different applications.
Example:
App Number App Description Item #
00250 FIXED FEE PAYMENT 000001
00250 FIXED FEE PAYMENT 000002
00500 PREPAID SERVICES 000001
00500 PREPAID SERVICES ... -
Using a combo box to populate fields
I am using a form that should have a combo that when I select a certain item from the list it populates the information from the table to the necessary fields. -
Here is my table structure for each table:
tblDometicAddre ss
InvoiceNumber (pk)
MailCode
AddressLine1
AddressLine2
City
State
Zip
Country
tblDomesticCont ract
InvoiceNumber (pk)
OriginalContrac tDate
OriginalContrac tAmt
ContractAmt
ContractDate
AmendmentDate
Terms
Conditions
Increases
t...Leave a comment:
-
Unfortunately I cannot post the tables because they contain important client information which I cannot divulge.
Basically the primary key is linking all of these tables up in queries. I am working with a form to plug in client information into different tables. The primary key is the same for all of the tables and a single textbox in my form is where you enter the primary key. Just hoping that instead of having to enter the primary...Leave a comment:
-
I have a access form that has textboxes and other data controls that link to about 10 to 15 different tables. the tables all connect by using the same INVOICE# key. Since I need the invoice# key to be in all of the tables I was hoping that there was a way to have a single textbox control in the form take the invoice# and plug it into more than one table....Leave a comment:
-
Single Textbox in a form updating multiple table entries
I am a novice to MS Access. I have about 10 to 15 tables that link to a single form. I use unique ID's to link all of these tables together. Since the ID for the customer never changes, I was hoping that someone could give me a hand and let me know if it is possible to add/update multiple table fields with a single textbox in a form.
Thanks,
JReneau35
No activity results to display
Leave a comment: