Search results

Thank you for fixing it Bob.

So I got a bit of a start on it (with some help) and now I'm getting a 2158 error. Here is the original code that works: Private Sub Date_Due_Back_Click() Me.Date_Due_Back = DateAdd("yyyy", 1, Me.Backup_Date) End Sub Here's what someone who helped me come up with: Private Sub...

Okay, so I was able to get it to populate to do what it is that I wanted it to do, which was auto populate 1 year after the date, but now, the person I am coding this for informed me that the "end of the year" backup tapes are kept indefinitely. So in the VB script, I'm looking to have an IF...

Access 2010. It is structured similarily to Access 2007.

So I have a general database question about forms. On an input form, I have two places where a user can input the date. I want them to be able to be able to type mm/dd/yyyy as any other date as mmddyyyy and it will then parse and set it up to look like mm/dd/yyyy. Is there a way to be able to...

Brian - that was exactly what I was looking to get it to do, thank you very much. Now to see if I can get the report to hold all the values.

The [backup date text] is the record in the table, called tapes, which was in my SQL link before.

Taruz, While that would work, I am still getting the same error that I was before about the expression being too complex.

So now, I need to be more specific with another query. I have it set up where it is querying the back up date text, but I also want it to be able to pull the year too, I get the error: "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric...

I appreciate everyone's help throughout this process. All seems good to go now and the data can finally be added to the database.

We need the date due back and the back up date in the table to print to the report because as I said, we re-use the tapes. Also, like I said, we are not going to be using relationships and they are not necessary at this time. The back up date is the date that the tape was taken out of the...

Okay, the way I have it set up is so that when you are entering data, the status is a combo box that you have to click on and select. It was done that way on purpose. We do not have relationships because those were not necessary at the point. The first two questions are answered by this: they...

Being that we had one record for testing purposes only, I have removed that. But you will need to input a number to do any testing. It is attached.

Yes, the table has a few combo boxes, but the odd part is that the other combo boxes are populating fine, it's just the one that is not doing it. As for the query, I could not find what you were looking for specifically. The report is based on the query: Tape Query Which has a SQL view...

Hopefully this is the last question for a while. I have a query that I print out into a report and the query is based on a form that has a combo box in it. When I run the query, the combo box populates with the correct information that was input into the table, but as soon as I run the report...

Sure can. SELECT Tapes.[Tape #], Tapes.Status, Tapes.System, Tapes.[Backup Date], Tapes.[Backup Date Text], Tapes.[Backup Desc], Tapes.Comments, Tapes.[Date Sent Out], Tapes.[Date Due Back], Tapes.[Tape Type], Tapes.[Date New/Cleaned], Tapes.[Type of Backup] FROM Tapes; Ah! I see the error...

No, the query did not call that particular record from the table. Please see the photos attached. The database 4 refers to the table where the record was stored database 3 refers to the form where the input box was located database 2 shows the error database 1 is the overview of the database...

In general, on a table, there should be one field per entry. For example: first name is one field last name is another d.o.b. is another and so on. Having a field that has multiple items in it can cause problems later on down the road.

So some, or many of you have noticed that I've been posting quite a bit in the last week about this crazy database I am working on for work. This is all in Access 2010 Now, I'm having a bit of an issue with this database. Keep in mind, I know next to nothing about access. I have a table...

Okay, so I know I've been asking a lot of questions about this crazy database, but I know next to nothing about database (as many of you can already tell). But, what I am looking to do is set a default print preview for any queries that are pulled. I know there's a way to do it in report...