Search results

Thanks JBB! I do not want to fire up the query separately. I want a split form based on a parameter query to work from a combo box selection. Yes, I am aware that the results should be based on the first column of the Combo Box. that is my intention. I inserted your statement into the...

I am using Access 2007 and have created a parameter query, and then a Form based on this query. I do not want a parameter prompt for the user, but instead a combo box drop-down list of all valid values! How do I accomplish this? I have been researching the 'Net and am getting confused. Is...

Thanks spikepl but I have done some modifications and it still tells me that it is noy updateable. I changed both tables to be imports, and I deleted the calculated field from the query and re-saved it. Then I deleted the split form and re-created it. What is wrong? Any ideas/suggestions?

I am using Access 2007 and have created a simple query using two linked (Excel spreadsheets) tables. I have now created a Split Form from it using the wizard(?). That is, I high-lighted the query in the navigation pane and then clicked on the Create Split Form button in the ribbon area. A new...

Thank you AccessMSSQL, I appreciate all the effort and input you have provided. I have been thinking about abandoning the parameter prompt approach and doing something similar to your suggestion.

Okay. Sorry, I was wrong. The filter property has [Formatted cost Code] = 'xxxx'. It seems to be storing that most recent prompted value that the user inputs. Is there another property that I need to turn off or set to false? Also, how can I keep the prompt when I want to run this form by...

Okay, this sounds good but a little confusing. I want to be able to run the Form B button by itself sometimes. also, yes there is [Formatted Cost Code] in the filter property of Form B. Should I remove this?

I have double-checked Form B. Yes, when I open it separately I am prompted for the formatted cost code value/field. Yes it does have this particular field and it is a text field. Does it matter if the record source for this form is a query built inside the form?

Thanks AccessMSSQL but it did not work. I checked and double-checked my typing. I am still getting prompted for the parameter. Can you think of anything else to try?

I am using Access 2007. Form A is based on a query with a parameter prompt for Formatted Cost Code. Later on I developed Form B based on a query that also has a parameter prompt for Formatted Cost Code. I have Form A in the Main Menu. I then set up a button for the user to open Form B. As...

Thanks Pat, that should work. I will give it a try.

I am using Access 2007 and have inherited a database. It has linked tables of Excel spreadsheets that are information extracted from our main system. The user wants help in developing a much faster and customized approach to billing the customer based on payroll related information. There is a...

Thanks Alansidman. But I inherited this database and I am in a crunch right now. Is there anyway you can help me trouble-shoot my macro?

Okay Paul, thanks. But can you please elaborate? I don't quite follow you.

I am using Access 2007. I have a form with a control that does a calculation based on two other controls, and all three are fields in the same table. The table is called tblWorkFile and the controls are RegRate and RegHours, and these are multiplied together in the control source for...

I am using Access 2007. I have a subform that has a control (ControlA) and its input value must populate a field in a table, TableA. There are two other controls (ControlX and ControlY) on the main form which provide possible values for the user to select from when inputting to ControlA. The...

Hi everybody. I am using MS Office 2007 (Access and Excel). Back on Sept 26/12 I posted a request for help. I wanted to create a macro (or VBA code) that would help test whether a particular spreadsheet has been opened. Trevor G came to my rescue and supplied the following VBA code...

Hi everyone....Happy Holidays! I am using Access 2007 and have a database that is working fine but would like to install a control-check on an input form. At the beginning of this form the user must enter a job identifier (JobID). However, this value may be closed out and therefore no...

Thanks, but can you please elaborate? What exactly should I enter into this property?

I am using Access 2007. I have a simple subreport that appears - as intended - beside a subtotal amount in a main report. I want to suppress/hide this subreport when the subtotal amount is greater than $1,000. How can I do this? I'm fairly new to VBA code and event procedures. Any help...