Search results

I'll go ahead and ask a question about it over in the VBA forum, thanks Brian!

Brian, before you posted, I had noticed the DateSerial code in a simliar database that will be replaced by what I'm creating. I was receiving an #Error with a record that I was using as a test record, but then realized that there wasn't a date for that persons transfer date, which is why it was...

Ok, figured it out. Now, the question is how to change between two different periods automatically, depending on the report. There's only two different time periods, one is 5 months out, the other is a month out. I've got about three different reports that require a 5 month prep time and...

Now, is that altogether or are those just seperate ways of doing it? So if seperate, I would have it as: Report Due: month(dateadd("m",-1, [duedate])) & "/01" Right?

I've got a query where I need a date calculated based on a date entered. For instance, I have a report (paper report, not Access report) that has a due date of say July 13th. What I want the query to do is based on whatever the due date is, automatically roll back to the first day of the...

vbaInet - Well, the dates change depending on the report, there is approx. 100-130 different reports, all with different dates. SOS - Would the Query work similar to a macro? Right now, I've got all my forms set to pull from Queries, so if I have to add a couple of fields into the query for it...

The dates are needed to be saved in the individual records. They are as follows Location 1 = 40 days from due date Location 2 = 30 days from due date Location 3 = 10 days from due date This is all for a form (frmReports), which (correct me if I'm wrong), if done right will save to the table?

I've got three fields with three different dates, all based upon one or the other for when reports should be turned in where. What I want to do, is have it set up so that whenever the report is due, the dates will be automatically entered, and updated if the due date changes. I know that in...

Ok, after using the If Me.RecordsetClone.RecordCount = 0 Then cancel = True 'MsgBox "No records in data source.", vbCritical, "Form OnOpen" End If And still using the filters that run before the form opens, it works perfectly! Thanks guys!

So say I have two fields, "MemberID" and "DecorationID", where would I insert these in the module? Also, how can I maintain the Open form and only display matching records? I have PK's and FK's set up in both tables.

Hello again... I've got a form that will open and display data for a particular user, but what I want the form to do is if there is no data in the child form a message box will pop up and say something like "NO INFORMATION FOR THIS PERSON." I've asked a similar question before for a report...

Let me shed some more light on this, because this is really kicking my butt. Currently, I have three tables, we'll call them Personnel, Reports, and Tasks. What I'm trying to do, and I know there has to be a way to do this, is tie the Reports and Tasks tables into the Personnel table via...

I've got a database I'm creating that has some sub-forms actually built into the form, but there are a couple that will be stand-alones, but still take the information stored in the main form. So, here's my question. Why won't my stand-alone forms not store the persons ID number with the...

To keep things simple, I simply placed a calculation field next to each box that requires a date. So the form will calculate the date, but it's up to the user to input it so that the it will be stored in the table. Redundant, yes, but simple.

Ok, thanks!

I might have asked this before, but couldn't find anything to support this. I've got a table which (for tracking purposes) has 4 columns for when a report is due to each office, based on its due date. I can manage the fields on the form to automatically update based on the due date. However...

I've got a problem. I posted a question early today, but deleted it when I thought I figured it out. I've got another database I'm working on where I'm using the similiar data to make a combo box much like what was discussed earlier in this thread. Everything works fine, names show up like...

Thank you FoFa!! Khawar, it's not a SQL database.

I'm building a query (if you saw my other thread, this is not for that database, but one I need to track a program). I've got a file in Excel format that I need to import roughly once a month. In this file, there is a field titled Pay Code in a A, B, C format. What I'm wanting to do, is I'm...

I just remembered the most important part. Since the people that have not arrived yet are not in the table where the position is, they, of course, don't show up. The table with the name and arrival date contains the information pulled off a much larger database (so information cannot be...