Search results

Greg P, Is this problem now resolved? Has the above correction made a difference? Dave E

Dear Anarch, My sincere apologies, In the line - Set MySet=OpenRecordSet ("tblGuests") change this to - Set MySet=MyDb.OpenRecordset ("tblGuests") I ran the code after this correction and it works OK. You will have to remember to requery the form/subform to see the changes on the form...

MyCount is a user-defined variable and is declared at the outset of the routine. If you change this to 'Cancel' then you will have more problems because Cancel is a reserved word for Access and it won't like it. With the first error - Sub of Function not defined, the line causing the problem...

In the Combo's Default Value Property type in the value from the query that you want as the default. It should work OK. Dave E

The only way I know to trigger anything in Access isby using the OnTimer event. Have a form, with a subform showing the data. This data would be linked to the main form by the BlockID. Have a field on the main form called BlockId. In the OnTimer Event, have a piece of code that will, every 5...

Pharmer Rob, I've knocked this together tonight for you to look at. It will answer a lot of your questions about multi-criteria searches. I'm sure it's not the only way - as others will no doubt testify - but it will give you a start. It is by no means a complete database, only an example for...

Pharmer Rob, I've knocked this together tonight for you to look at. It will answer a lot of your questions about multi-criteria searches. I'm sure it's not the only way - as others will no doubt testify - but it will give you a start. It is by no means a complete database, only an example for...

I've used Time() and selected Short Time as a Format. Try that. Dave E

I find the best way to achieve total control is not to have a data entry form populated from the table. I use all unbound fields/combos/checkboxes etc., and have a Save button, which verifies all the inputs and then saves the data to the table(s). The exits are trapped by code which asks if the...

What about forgetting the Autonumber and having an additional field (Counter) set up as a number field. Start by just numbering them 1 to 20. Not to be used as a primary field! This is in addition to any key fields. When you need to revise the list , after a deletion etc, use the code below to...

What field(s) are used to store the date/time for the record and how do you want to relate this date/Time to the 3 timeblocks? Would you want 3 buttons on the form - one for each timeblock? Dave E

For 3 criteria I would look at the database attached below. I got it from the forum; it was posted by Candace Tripp and is one way to use Cascading combos to filter information. If this isn't what you're looking for then I have a multi-criteria search routine that I found and modified, which...

On your search, did you find the example attached below? I got it from the forum a week or so ago. Dave E

That was what I had in mind when I said about using code to pre-process the data before printing the form. But the more you think about it, the harder it seems to get! Restructuring the tables may help, although you've still the problem of predicting how many categories and codes under each...

Where are you going to find a nut at this time of the day? Oh, yeah, I'm here, right.:D Dave E

Pat's sort of right.... I used the OnTimer property so that the call screen had the date and time continuously displayed, but when I saved the record all the fields on the form were unbound so were saved using code. The calldate and calltime were saved at that moment. It would just mean opening...

I think so... Somehow you've got to get Access to do something it's not designed to do, i.e. look at many values of the same field at the same time! The only way I can see to do this is to pre-process the data before printing the report, but that's not easy because you may not know how many...

As a matter of interest, where did you put that bit of code? Did you go into the Code Builder, or Macro facility? Dave E

You could try DLookUp() function. ThisField=DLookUp("[Faculty_Name]","[MyTable]","[Faculty_ID] =[Forms]![My_Switchboard]![Combo8]") (It's all one line...) HTH Dave E

It's an interesting problem AutoEng, It sounds like you need a function like the Tab Order in the View menu. Is there a logical order that you want the 20 records put into? Can it be sorted using code in some way? I can see a way to copy/cut the record into a temp location, but as yet I...