Search results

That's great thank you.

Sorry, I tried to keep it as simple as possible! I don't normally program using visual basic so I'm sure the answere will be simple. The question should read: How can I cast a string into a long? Now tell me it can't be done in VB! Paul :o)

Hi I'm having trouble casting a string into a long as a pointer. I would then like to dereference back into a string. Any help would be greatly appreciated. Paul

.....But! In a previous query it would not work unless the text was refered to eg. [Forms]![YourForms]![FormNames].Text

It was as simple as I thought, a couple of syntax errors at the start caused the errors! The final statement was: WHERE (((Format([Last day of sickness],"mmm/yy"))=[Forms]![PERIOD SELECT]![Combo0] & "/" & [Forms]![PERIOD SELECT]![Combo2])) OR (((Format([First Day of...

Hi again! I am trying to sort records on a couple of fields which are Start Date and End Date. The user selects a month and a year using 2 combo boxes (see previous post), and I would like an expression which will do the following: Show only records where The end date is in the month and year...

I have now worked out the problem! The expression should have read: [Forms]![PERIOD SELECT]![Combo0] & "/" & [Forms]![PERIOD SELECT]![Combo2] Can anyone tell me why you sometimes need to index the Text in a combo box and other times you don't? Thanks Paul

Hi I have a form with 2 combo boxes on to select the month and year for the criteria of a query. The date has been formatted using Format([Last day],"mmm/yy"), and the first combo box has the month in, and the second the year eg. JAN 02. Can anyone help me with the expression I need to...

I think I may have some sort of date format problem as I have now entered some data for today's date and it brings that up. It also brings up data from the same day of any month eg. if my criteria is Date().....it will show records with 21/01/2003, but also 21/09/2002! What date format is...

Hi I am trying to sort out some records into the last year to date. I have been trying Between (DateAdd("d",-365,Date())) And (Date()) but this wont work. Any ideas? My next step is to consolidate the information from the last year which will include a number of entries with the same name, a...

I have now worked out why it wasn't working! I needed .Text after eg. [Forms]![FormName]![Combo6].Text Thanks for all your help Col. I'm sure it will be needed again in the not too distant future! Paul

You know the saying 'It never rains but it pours'! Well that's what my day has been like! I've been trying to attach a copy of the database for the past 30 minutes and I can't get the file small enough. I've zipped it, which got it to 132kB, then tried deleting lots of reports and queries that...

Right....I see the first problem! I need the form open when I run the query, I was expecting the query to open the form! Now the query runs but doesn't seem to produce anything no matter what I select in the combo box!

Sorry for the confusion.....I didn't put it in quotes, and it put the square brackets in itself!

Thanks for your hepl again Col. I must be doing something stupid as I've tried this time and time again but when I run the Query a pop up box appears which says "[Forms]![SurnameSelect]![combo4]", rather than showing the Form required! Where am I going wrong?!!!!! Paul

Hi I am trying to get a query to call a combo box for it's criteria, but I can't seem to get it to work! Any ideas? I have a database with a load of records and I want to select only records for a specific person. I have it working with [Type Surname] but would like a list of all surnames to...

Hi again! It does pick up on where the sickness started and shows all records where the last day ends in the specific month. Now my problem is with the form! I can't seem to get the query to run with the criteria I set in the combo box on the form. After I select the month say from the combo...

Good point :-) I will use the last day of the sickness rather than the first as the criteria. This will only then include sicknesses that are complete and have all the relevent data. I have now managed to half solve the problem by using Format([Last Day of Sickness],"m/yy), and then [enter...

Hi I am trying to write a sickness record database to make my life easier, but it only seems to be causing me lots of headaches! I would like to run a Query which displays sickness records for a specific month. I have a 'First Day of Sickness' field which I would like to use in the criteria...