Search results

I would use an autonumber field and combine that with things like Year([DateRecordCreated]) to create the reference number in all my queries. However, it's worth keeping in mind the limits of autonumber such as missing numbers (from deleted records) not being reused. This means your...

Use this as criteria: Between [forms]![FormName]![StartControlName] And [forms]![FormName]![EndControlName] Obviously alter the form & control names to suit your form. Alternatively this will give a popup input box asking for the date (which may be better for some situations: Between...

Hard to say, given that I don't know if we are talking about 2 completely different tables or 2 queries with slightly different criteria which are based on the same table, etc. It could be that you only need to set a field like "IssueStatus" to "Closed" and requery the forms (which an update...

I assume these are 2 forms bound to different tables / queries? If so you don't change which form it is displayed on, you change where the record itself is (e.g. append it into a new table and delete it from the old one).

Yes you do, however if transferring the code to a new module has caused issues then chances are it's referring to something like form controls, etc. Can you post the code from the module?

Also exactly what the function I posted does (pull the windows login name). However the OP sounded a little confused, so further discussion was required.

What if you do CInt(Round()) so it's converting a double which holds a whole number?? I only mentioned int because he specifically asked for a way to convert it into a whole number rather than something with decimals.

I only have 2003 on this PC so can't open accdb files, but you should be able to do what you want in the keypress event of the combobox, the code being ComboboxName.requery However, I don't recall if it resets the focus in the control (i.e. moves cursor to the beginning / selects whole...

CInt() works the same as above and integers are whole numbers only. However, you may want to test that it rounds decimals as you would expect.

Lets clear up whether it's a viable idea first. I'm assuming your PC / network has some security and therefore everyone has a unique windows / network login? If so there's no need to ask for another usename and password if you can check who they have logged in as. If not then you can ignore...

And just to check the bound column can you do this (should have included that in the last post): msgbox CboOutletSize.Value

There's a difference between not having an original thought and dismissing something which is proven wrong. If gravitational waves have been proven not to occur then disagreeing with a hypothosis which includes gravitational waves does not make you a nay-sayer, it makes you rooted in reality...

The form is continuous if it shows all the records in the recordsource rather than one at a time. Generally I find it's more for subforms than mainforms, but not exclusively. msgbox "Column0: " & CboOutletSize.column(0) & " Column1: " & CboOutletSize.column(1) I forget if the column...

It's generally agreed that calculated fields should not be stored. Storing the full date and a month which is calculated off of that date means you are taking up more harddrive space, etc than required. There's no need to hold the same piece of data twice. You can use the DateAdd function if...

Nz() should deal with nulls: 'Nz([Field Name],[Null Replacement]) 'e.g. Nz([BlahBlah],0)

And are you certain the correct column of the combobox is the bound column? Have you tested what's being output from the comboboxes via msgbox or debug.print?

I'd avoid field names like Date as Date() is a function. I always try to use 2 words to try to avoid that, like JoinDate, RecordCreationDate, LeaveDate, ChangeDate, etc. I think the format property will accept "mmm, yyyy" in the properties, but personally I'd want the table to hold the date...

A date field should be enough. If you want to filter it further for reports you can do so in various ways. For example, if I wanted to use a month as a criteria where the field is a full date I might use: Month([DateField])Which would return an integer containing 1-12. Alternatively I...

The new field would be something like DefaultForm and would hold the name of the form which that person loads. If the combobox is then changed from 2 column (with only the name column visible) to 3 column (with only the name visible), and refer to column 3 in your OpenForm command instead of...

If the link to the database uses the /cmd switch you should be able to pass a parameter (e.g. the PK of the record in question) to the instance of Access which is loading. http://support.microsoft.com/kb/209207