Search results

Brad Many thanks for your comments :). However it's Mile-O-Phile who deserves the credit on this one as he gave me the code a couple of days when I was trying to solve a problem with looping through the selected items of a list box and appending them to a variable for use in sending email...

You'll need to add to both tables a field called say PeriodID and then link the 2 tables on this field

You might want to change your query to a cross tab query in order to get the desired grouping and results. In the design of your query go to the 'Query' menu and select Crosstab Query. In the grid this will add a couple more lines..Total and Crosstab The cross tab allows you specify how you...

You might want to change your query to a cross tab query in order to get the desired grouping and results. In the design of your query go to the 'Query' menu and select Crosstab Query. In the grid this will add a couple more lines..Total and Crosstab The cross tab allows you specify how you...

You should be able to do it in '97 as well. Unfortunately I went from '95 to 2000 to XP

Hi Mile-O-Phile / Chewy In Access 2K you can create your own menu by going to Tools--->Customise. Go to the 'Commands' tab and under categories their should be 'New Menu..'. Just drag this upto the menu bar. By using the right click you can alter the menu bar properties. To add bits to your...

One thing you could do is to create a list box that is based on your table containing these preset terms, make list box multi select and then you can loop through the selected item(s) and add them to your memo field. Have a look at the attached...this should get you started. Rob

Assuming that when you run the query it's retrieving the correct data, then all you have to do is create a new field in the design of your query and enter the IIF formula in the 'Field' section of the grid.

What I would do is in the report's recordsource (assuming it's a query) is create a calculated field that uses the IIF statement e.g. IIF([Actual_Date]=Null,[Proposed_Date],[Actual_Date]) Then in the report, for the Actual Date control, change the source to this calculated control. HTH Rob

Hi there There is no sorting or grouping that I know of in the design of a form like you can in a report. One suggestion you may want to consider is using a crosstab query and then base your form on that. Unfortunately I don't use crosstab queries very often so the only thing I can advise is to...

Glad you got it working! I know in the past I've gone around in circles trying to sort out calculations but like everything else I've got there in the end ;)

Hi there, This is how I coped with the problem which may or may not be of use to you. I have form with a subform which is used to enter a purchase order and I wanted to create a total value of order field on my main form. In the subform are the details of the goods ordered and for each record...

Hi there, Search these forums for 'Disable Bypass Key'. I did this the other day, there are plenty of posts relating to this and also a sample db to download.

Hi there, Yes I thought of that after my last post, so I've swapped the columns around and set the first column to 0cm and everythings working fine now. Many thanks for your help :) Rob

Hi Mile-O-Phile, Many thanks for your quick response. I've made use of your code and it's almost working. Unfortunately I neglected to mention that my list box is displayed as Name, email address. Using the code it picks up the name obviously because that is the first column. Now I could...

Hi guys, Well I've been searching through the forums trying to find an answer / help with my problem but I've just ended up confusing myself :( Hopefully someone can help me out and I apologise in advance if similar posts have been made before :D Basically I'm trying to send a standard...

Hi Aziz, I apologize, I think I was half asleep when I read your post :o I think you are correct in that because your subform is in datasheet view you can't hide a field. Have you tried it in another view like continuos forms to see if it works?

Hi Aziz, You need to reference the control in full: Forms!frmMyForm!frmMySubform.Form!myControl.Visible = False HTH Rob

Just add to your MsgBox code +vbDefaultButton1

Public myVariable As String = "Hello" You can also declare a constant in the same manner Public Const myVariable As String = "Hello" HTH Rob