Recent content by 12asd

Not yet, I only have the rest of this week and next week on Access before I move onto HTML and websites.

I want to include a CombBox in a form and only display certain records, the combobox will reference a table for all the records, however I only want specific records to be displayed. For example, say I have: Column1 Column2 Column3 Where Column1 and Column 2 have to different piece of...

Well for example, I have no idea what these all mean: Option Compare Database Option Explicit Dim <name> as <type> debug.Print

OK, but I really don't like vba, besides I don't need to learn it for what I'm doing. Though it is allowed, but from what I've seen on here, vba seems complicated to learn :confused:

I found a solution here: https://social.msdn.microsoft.com/Forums/office/en-US/2a8c15f0-91a2-4188-a295-c3894daf490f/how-can-i-calculate-time-difference-between-start-time-and-end-time-even-if-date-is-different?forum=accessdev

Because what I'm doing this for doesn't require us to learn vba, it is optional to use vba for forms, but we usually do append queries or expressions. In the query I got it to work and managed to output the number of seconds.

arnelgp and ridders, I'm not looking for a whole load of vba, I just want to use a simple expression involving DateDiff() like what I had in the original post.

OK, well: 1. The times are written without the AM/PM 2. Not sure what Diff3Dates() means, besides it is not being done with vba but the simple expression builder. 3. I'm not entirely sure how the interval works, so the 'm/d hh:nn:ss' would be a test sort of thing.

The field names were already there, this is a practice table I'm working on and I'd rather keep the default names.

Yes, but as arnelgp said, hours weren't supported apprently. I would guess so. Though what about the error I got? What does it mean and how do I fix it?

Try creating the table using the different fields from each table, then create the form you are going to use, making sure to properly label all objects for later use. Once you finished the form create an append query to THAT table you created, use the builder function to get a value from the...

The quote was put in automatically. What set of parameters would get me month, day, minutes and seconds?

This goes with both tables and queries but I'm trying to get the difference between two dates and times in a table. The code I'm using for the default value for a field in a table is: =DateDiff("m/d h:n:s",[Date/time reported],[Date/time resolved],"vbMonday") Where [Date/time reported] and...

I know about that, it is just that I wasn't sure how to properly write that.

I'm working on a login form but I can't seem to get the vba code to work. The main part of the code I'm using is: The code that gets the error is: with the error: Syntax error (missing operator) in query expression 'Access level'. I'm not even entirely sure what this means or how to fix it...