Search results

There are a few ways that you can do this. In this thread http://www.access-programmers.co.uk/forums/showthread.php?t=78230 Cable has posted one example Db that works well and will achieve what you are trying to do. There are other options (eg multi select listbox) that can do a similar task...

Yes it can be done......easily. Use the Link Tables wizard (File -> Get External Data -> Link Tables) and select the XL spreadsheet as your data source. Be aware though that XL is essentially a flat file data storage system and therefore creating relationships such as 1-to-many is nigh...

This gets a little more complex but why exactly do you need to feed a query criteria with a value from another table? This makes me think that you are trying to force it which generally indicates a non-optimal query design or data structure.

Sorry Bain, missed that bit of the question :o But...in my defence, it is the easiest way to achieve what you are looking for and you can make it clear that the button will print the report by formatting the form as you need to :cool:

Is there any reason why you cannot have a LEFT JOIN in your query? If you are not sure what that is, post the SQL code and we'll adjust accordingly

Create a form with an unbound textbox where you can put enter the date parameter and the report(s) can take the value from this form. If you want to make it a little slicker, open the form instead of the report, put a button on the form to open the report and close the form when the report...

Single quotes will normally suffice except if your field may consist of strings with an apostrophe eg O'Connor etc In that case, try sql = "select * from [tablename] where [fieldname]="& """ & criteria & """ but generally using Like is better for string comparisons. However, if the field is...

If you use a query. you can produce a filtered recordset whenever you like without destroying your original data. it you really need to remove data, either use a delete query (carefully) or use an append /make table query to post new data into an existing / new table

Have a good rummage using the search facility as there have been a lot of posts (especially recently) on how to create a custom incremental ID. If you cannot find a useful solution, post back.

Having a quick look at your Db immediately brings up data structure problems. Rich has set you off on the right track. Re-evaluate how you need to store data as you data structure and therefore forms are making it difficult for you to track data effectively. Your report rpt_test violated 1NF...

Create a query to power the form. Get out of the habit of powering a form directly from tables. It is generally considered more effective using queries as you can narrow your records and select the relevant fields to show on the form. Depending on your table joins, (1-to-many or 1-to-1) will...

Far too perceptive, as usual :p Why did this cause problems - if you split into FE/BE (or even access the same Db), this should not create difficulties.

It sounds like your data structure and form structure are just looking for trouble! Take another look at how you are structuring your Data and Forms as suggested - it will cause a hell of a lot less headavhes in the long run :cool: You cannot beat double Geordie advice! ;)

If your controls are in the detail section Detail_Format() 'Simple Version if not isnull(me.NameOfCheckBox) then me.NameOfCheckBox.visible = true else me.NameOfCheckBox.visible = true end if 'Better Version Dim ctl As Control, rpt As Report rpt = Me.Name For Each ctl In rpt.Controls If...

It depends on your form structure and how you use the dropdown box. If the manufacturer dropdown changes the main form data, setting the master/child links will force all the subforms to requery as well. If the combo only affects the subforms, you could 'cheat' and contain all the subforms in...

Yep, that is another way of hiding the value but keep the label for the textbox and make sure it sits on top of the textbox you have doctored. Use the On_Click() event of the label to run the code behind your button as when you click on the label it will set the focus to that record...

If that is your actual data in each record, then you will have a hard time trying to summarise, total etc the field as it is non-normailsed data. Personally, I would alter the structure to split the data into its smallest parts '25 = Red' becomes '25' and 'Red' then you can summarise much more...

hmmm, The simple answer to your question is no, you will need to requery every subform unless you have the Master/Child links set for every form then as the manufacturer changes, the subforms can change as well to keep sync However..... My main concern about your position is that your data...

Is this the actual data in each field or does it indicate that 25 records have Red in the field, 25 have blue etc?

In the properties of the form (format section), you can turn off the control buttons on any form including min/max, close and help button. Also changing the border type can have an effect on which buttons are available