Recent content by sammy16

Happy New Year everyone.. If I have a text box on a main form and then I want that value to be displayed in a text box on a sub form. The sub form is based on a query and the main form is based on a table. If the project has data in the query it displays fine but if a new record is entered into...

Is there any way of displaying a message in a field on a report if there is no value being passed from the query? If so would you just put the code in the control source of the field in the report? Cheers

Hi all I hope someone can help me this problem I have a form (frmtransaction) showing all components for a project. I have a combo box at the bottom of the form query tblComponents for the list of components avaiable. If you need to add a new component you click a button to enter this in...

Do you really need the second combo box to be a combo box? You could make the second combo box just a text box and enter =[Cbo1].[column](0) in the control source of the new text box's properties.

I'm sorry I'm not sure where you mean by the query combo. I choose a Team Leader from a combo box fisrt and then the project list is based on the team leader selected. Should I call the code in the after update event of the Team Leader combo box?

It should be.

I hope this makes sense and someone can help! I have a combo box on a form where I can select a project number. I then wish to base a query on the selected project number to tell me the total project time entered in by each team member. The problem I have is that the project numbers are entered...

Cheers for that it works now :)

Hi I'm trying to export a report with OutputTo but it gives me the following error:. Run-tim error '2024': The report snapshot was not created because you don't have enough free disk space for temporary work files. This is what I have: 'DoCmd.OutputTo acOutputReport, "rptRegion", acFormatSNP...

unfortunately no as the value held inthe first combo box is not unique it is an area code with many regions for the one area. I want to display the region code for that particular selection.

I have a form with 4 combo boxes. One of the combo box's source data comes from a table with 6 columns but only the first column is bound when selected. Is there anyway I can have more than one value as I need to use one of the other colums for a select statement in the code update() to enter a...