Search results

In an Access 2010 form, I have two combo box fields 1) BroadastType and 2) Station. Properties of both fields are set to accept multiple values from combo box. Multiple value select is a new feature in Access 2007 and 2010. my question is; if I select 'Nationwide' from combo box in...

Thanks, Sir. It worked. Now another request: If value of 'BroadCastType' is equal to 'Worldwide' then I would like the 'station' field to automatically select all items from the combo box. The station field itself is a combo box. Would you help me with the procedure? Thanks so much, Dad

Here you go...

This one: if me.broadcasttype="Nationwide" Then

In a form, I have two fields 1) BroadcastType and 2) Station. BroadcastType has a combo box with multiple value select property enabled. In 'after update' event property of 'broadcasttype' field, I have written this procedure: if me.broadcasttype="Nationwide" Then me.station.enabled = True Else...

Sorry for the confusion. Station is a field that has a drop down list of radio/tv stations. Values for station field can be one or more from the drop down list. This again means that station field is a combo box. :)

Dear Access Experts, In a form, I want to set values in 'Station' variable based on value selected in 'BroadcastType' variable. If the type of value is 'nationwide' in broadcastType variable, then I want the 'station' variable to automatically select all values from the combo box list that it...

Easy way would be to view this SQL query in Query Design View. Then in criteria section under the mfgdate field, type the required If condition expression. You can do it to as many fields as you need.

Set 'format' and 'input mask' both to short time in the table. If you want to change it on a form, right click the field, go to properties, and set both format and input mask to short time. It will not ask for seconds.

Here is an example of code that I use to generate optional reports using conditional statements... It might give you a hint how you could proceed. SELECT Tab_Obs_Stip_Form_Mom_SuNDE.Date, Tab_Obs_Stip_Form_Mom_SuNDE.State, Tab_Obs_Stip_Form_Mom_SuNDE.County, Tab_Obs_Stip_Form_Child_SuNDE.Name...

On the form where you click the button to execute outputto command, create a date text box. Then link this text box to all those queries. In this case, all queries will consider the date you have provided in the textbox. From link I mean something like, if the OutPutTo command button is on Form1...

Exactly. U don't need to delete a table if you want to change an existing table in a query. Simple go to design view of query, click on 'Show Table', and from there add the table that you want. And right click on the upper bar of the previously opened query and select 'remove' which will remove...

Yup. If I understand you correctly, you can go with your composite key and link it to the sub table as 'One To Many' link - in case only if the sub table is a child table. If not a child table, you can link them as 'One To One' only. My experience is that making the PK a composite one saves time...

Split is the only option. Before or after split (before recommended), make sure the record locks for each table is turned to "No Locks". Also on the Access Options, make sure the record locks is set to "No Locks". Then many more users can edit and enter data at the same time.

I would suggest that you create append queries from the main 'employee' table to each of the sub tables. And then create a macro/vba code that runs all these queries. After this, add this macro/vba function to the button that imports data to 'employee' table. This means, after successful import...

It means all items that don't have departure dates are in the store from the date of arrival. For Nov, your total items stored would be all entries where departure date is null. For Oct, your total items stored will be any item arrived before Nov 1 where the departure date is null or the...

In design view of query, under the arrival date of items, type below expression in criteria Between #01-Nov-11# And #30-Nov-11# You can provide a lot more criteria based on what you want. Search for more criteria on Access Help.

There are advantages and disadvantages of using lookup. I found lookup fields very effective and useful in data consistency. It can help in tables, forms, queries, reports and all sort of analysis and can be used anywhere when required. Could you provide us with more specific concern or...

You should have a text box let's "Balance". This balance box should have an expression to sum up all expenditures and subtract the expenditure from the budget for the line-item such as =[Fildnameofavailablebudget]-sum([fieldnameofexpenditures]) This will sum all expenditures and subtract it...

I think they have changed the old way. Would it make sense if you add a new button to go directly to the last record or new record. It can be done pretty simply from command button wizard (record navigation commands).