Search results

Thanks Rural Guy, I'll add and then modify your code accordingly. It looks great. Thanks again, I'll come back to you if I encounter any problems.

I created a database which was working well. I then added my data and it still seemed to be working well. Since then I have made quite a few other changes, but only to queries realting to the subform. When I cycle through my main records the subform shows and displays all the info. But when I...

I have a number of combo boxes linked to respective individual tables, for example tool combo look up the tool table which is composed of ToolID and Tool Type. I want to be able to add additional tools directly into the combo box on the form when I come across a tool type that isn't in there...

Hello, I am trying to incorporate a traffic light system based on numerical scores from a calculated box. I did a search on the forums and adapted a code which somebody suggested to conditionally change the colour of text. I want to do the same but only by changing the fill colour of an...

Fixed it at last. There was a probelm with one of my combo boxes being bound to a mispelled fields. I also re-wrote the queries that the row sources were based on and it's now working. Must have been an error in one of those.

Thanks for the response, unfortunately I've had no luck using your method so far. I have been adjusting my queries which is possibly where the problem may lie, but I still can't get all three to synchronise.

ok, thanks. I'll try that then

I have been reading previous post s regarding the storing of calculated fields. Basically everybody says don't do it. However, if I don't I am not sure how to achieve what I need to achieve. I am storing data on tool vibration levels. Data is input for X, Y and Z axes and a vector sum (total)...

Hello, I followed the Microsoft guide detailing how to set up two cascading combo boxes. I would like to add a third box to the cascade. I have tried making some assumptions based on the code in the example but I can't get it to work. I have three queries set up; qryBusiness, qryBusinessUnit...

Found it thanks. There was an error in my naming buried in my IIF criteria in my query. I'll remember to check these in more detail next time. Thanks

I have managed to set up a cascading combo box by following this guide: http://support.microsoft.com/default.aspx?scid=kb;en-us;209576 I have two boxes - [BusinessUnit] and [Location]. When I load the form or select one of the [BusinessUnit] I get a box which prompts me to enter a paramter...

I would like to get my reports to count the number of entries (text fields) in each report generated and place the total at the end of the report. I have tried using aan unbound text box in the footer of the page and setting the control source to Count ([Field] but I just get 'Error' back...

Your guess was spot on. What am I looking for in the properties? there are two columns and it is bound to column 2, which is the location names and not the IDs which is what I want. Do I need to change it? Or were you just explaining why it did what it does? Thanks for the prompt on...

Scott, It's rather strange. When I run the query and select the desired location, the query doesn't show any results. However, if I load the form that the query is based on as you suggested. Then select the location in the combo box and then click the preview report button to load my report...

It's all fine. I am in fact quite stupid. I was messing around with the auto object function. By selecting the location in my drop down and selecting autoreport it generates a nice shiny report with all the relevant names as per my query. I guess all I need to do is make a report template and...

Thansk very much for your reply. I have set the criteria in my query to: [Forms]![frmFilterBySelection]![Location] I still get nothing. Have I done something wrong with the string in the criteria box? Thanks

Query By Parameter Hello, I am trying to set up a query by paramater to then base a report on. For example, I would like to input a location name to get a query to only display the records for the specifiied location and the accompanying data for use in the report. How do I do this? I have...

Hi there. I tried that earlier today but it still doesn't seem to work. Maybe I'll go back to square 1 and rebuild it from scratch. Thanks anyway.

Hello, Yes, it is a subform and yes you would think it would be a simple question of linking one tool to many tests but I can't seem to do it. It will almost certainly because I am a pure amateur but I can't see the problem despite it probably staring me in the face.

I still can't get this to work. I have tried the following: 1. Add an autonumber ID field as PK to an intermediate table [TestDetails] 2. Add an autonumber ID field as PK to table [VibrationMagnitude] Linked table [GeneralToolInfo] to [TestDetails] PK [Serial Number/Reference] to FK [Serial...