Search results

Your code is not complete but it would seem that your i happens to take a value superior to the upper bound of your array (countselected)

Yes. However, the easiest way to know would be to just give it a try, don't you think? :)

From what you described it sounds that you should have a separate table for diseases, and not store diseases related info in the patients table (these are different topics!). You should not either have extra fields for relatives (again, it's different topic) in your patients table. Here your...

No. But you should be able to do it from where you are opening your query (You say you wouldn't use a command button... But if you do not provide other info is difficult to give you a more accurate answer)

Your approach (search form) is fine and makes perfect sense, and I am happy you got it to work. Moreover you are telling me that your Clearance table does not duplicate fields from your Equipment table, which answers my question and shows that my concerns were not relevant. This is somewhat...

Well, there would be workarounds around this but before getting further I'd like to understand how you get such behaviour. Are you using the switchboard created by the Wizard or a custom one? The one created through the wizard will not close on opening a form (pop-up or not). At least, I made...

Yes, a good many exaples were already posted to this forum. You should do a search using the keywords Query and Listbox. Ex: Use selected items in listbox for action query

Only variants can (eventually) be evaluated to 'missing'. For other data types, you will have to define a default value and do some good old checking: Function Test(x as Date, Optional y as Boolean = False) If Not y Then ... Or (less efficient, but if you really need to...) Function Test(x as...

255 fileds in a table most certainly means that you did not normalize your structure properly, but probably directly adapted your table from a spreadsheet... Let us know more on what is your DB about and the tables and fields you have. It is very important that before anything else you do some...

Missing single quotes around text values: stLinkCriteria = "[Top Level Assy No] Like '" & Me![Text31] & "*'"

ksgirl, Sorry to insist, but your justification is far from convincing. I would say you just need to store in your clearance table the equipmentIDs, and link that table to your 'Equipment list' table, so that you can retrieve the other infos whenever you need (using a query for example). BTW...

Use the OpenArgs property of the form you are opening to store the name of the form you are coming from (have a look t access help on OpenArgs for more info). However, it is generally more efficient not to open and shut and re-open forms. You should consider either using popup forms (eventually...

My 2 cents: You would not embed the documents in your DB, just register their path (this assumes that on registering a file, you create a copy into a secured folder for users not to delete/move them afterwards). To open those files from your DB, you would use either an hyperlink data type, or...

Allow me an observation first: Hopefully, the blank controls you want to fill on your Fomr1 are NOT meant to update an underlying table. If they are, you are duplicating data in your database... So I assume these are unbound controls. There are probably various ways to achieve what you want...

I believe that what you are looking after is called 'Custom Menu bar' in Access. Search Access help on those keyword to see if it matches your needs. Re-post if no luck.

You have to specify the parameters programatically. See if the following post can help Open parametered query

Use the OpenArgs property of your forms. Ex: Pass a vaue to a form you are opening docmd.OpenForm "YourFormName",,,,,,YourValueHere Read the value from the opened form: Debug.Print Me.OpenArgs

You can either: -resize the footer by setting its height at run-time Me.section(acPageFooter).Height = ... (in twips) -or at the contrary force the last detail section to the next page when you detect that: the page total height - total heights of (details sections + footers + headers) is not...

Report footers dipslay on the last page only. Page footers on every page. Page footers have a property (right-click menu) allowing not to display them on the samepage than the report footer.

If you can foresee a maximum number of segments you would create them right from the beginning, make them invisible, and save your form like that. Then at run-time based on a count of the records you have you would make a loop to set those textboxes visible and resize them. This does not require...