Search results

Thank you Alanidsman. I started with your post first and used DateAdd. I just hope it will calculate for the leap year. So far it's working. Here is the code I used. =DateAdd("yyyy",3,[FieldName])-1 I was able to get my ([Date Sent] + 3yrs) - 1 day using that.

I have two date fields. One "Date Sent" the other "Next Due Date". I've been asked to just take out the "Next Due Date" field so user's don't have to type it and just basically add a text box that will display the date equal to "Date Sent" + 3years - 1day. However, I began to think. what about...

So i've decided to just use a form to alert the user that they need to wait; however, when the update button is clicked, the form opens as blank, texts fills after the excel file imports, and the alert closes. So far i've read that there is not wait function in Access. Is there any way I can get...

Thank you for all of the responses. Is there a way to code the progress bar from the bottom of the screen on the status bar to a form. The progress bar at the bottom of the screen is accurate. I just have a feeling people won't pay any attention to it.

Just in case you need to see how my progress form works, here is it's code: Option Compare Database Option Explicit Dim ClockName As Integer ----------------------------------------- Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open ClockName = 1 Exit_Form_Open...

I currently have a form that is just a progress bar. It uses an timer on open to basically always run a bar from left to right to show processing data. I have another form that imports an excel file. Here is the code for that: Private Sub Update_Click() On Error GoTo...

I know enough about code to usually change it to make it work in my databases. I'm currently using this code to open a file browser to pick a file, but after I pick a file and choose open the browser opens again and has me choose a second time. I'm not sure why. I've tried deleting out some...

I'm currently using the following code to update a table from an Excel file. Private Sub Command0_Click() On Error GoTo Err_Command0_Click DoCmd.TransferSpreadsheet transfertype:=acImport, tablename:="Updated Table", FileName:="C:\updated.xlsx", HasFieldNames:=True Exit_CmdImportExcel_Click...

Let's mark this thread as solved.

Thanks a bunch. I kept getting syntax errors, but then I realized there was a 1 after fieldname of MIDNAME to notate how many characters from the left.

I had trouble naming the title for this thread, but here is my issue. I have two tables. Both contain the fields "LASTNAME", "FIRSTNAME", and "MIDNAME". I need to compare table1 to table2 to if a person is in both tables. This is needed because a company has their table and they receive an...

I think I might trash the DailyJob and JobList table thing I've got going on and just have the joblist. The user can just enter the two or three fields that were on the DailyJob on the JobList table. I'll then add the billables and timecards to the JobList Form instead. Most of the issue was...

I've come to realize that if I was more familiar with all of the various ways to do things in Access I could have had a lot better design.

I appreciate your help. I've not really worked with triggers or junction tables. I wouldn't mind uploading the DB, but i've had others link very small database with an example if you had one handy. I could probably look at it and figure it out and keep you from having to look at what i've going...

Sorry, I missed your question about the difference between JobList and Daily Jobs. The company does drilling work at multiple locations for different customers. So, when a job started for a customer the job is put in to the JobList with info about the jobsite and customer. The DailyJob contains...

What I want is to be able to go in to my JobList, fill in the date finished, and have the date finished also entered in to the DailyJob so it's marked as finished. I use a query to open the DailyJob form that looks for DateFinished "Is Null" so when the user goes to add billables or employee...

Currently, the Daily Job is a seperate entry. A form is used to create a new job in the job list. Then, I open a form for DailyJobs. The DailyJobs form has fields: DailyJobID, JobNumber, Work Description, Date Finished, and Billed. The field JobNumber has a row source which pulls data from the...

I have a one-to-many relationship using the field DailyJobID in [DailyJobs] to DailyJobID in [TimeCards]. I also have the same one-to-many relationship using the field DailyJobID between [DailyJobs] and [Billables]. I currently don't have a relationship between the table JobList and DailyJobs...

I have multiple tables. First I have a table [Job List] for a user to enter new job sites which has a "date started" and "date finished" field. I have a [DailyJobs] table which on it's data entry form has 2 subtables [TimeCards] and [Billables]. The relationships work fine for DailyJobs and the...

Sorry about not answering your question. I want the tag data to be erased/deleted. The change will be permanent. Basically, I have code that checks some data I put in a tag of a form. If the criteria of my code is true I would like for it to delete the data from the tag permanently. When I asked...