Search results

Is it possible to do the following? I want to create a table which would list every date of the year 2002 and a corresponding number of hours, eg for Monday the hours would be 8 but for Saturday the hours would be 0. Then I want users to be able to enter a "from date" and a "to date" in...

I don't have a definite solution unfortunately. I tried chaning the datatype to hyperlink but that doesn't seem to work for mailto: hyperlinks. Maybe somebody else knows how to do this? What you can do is change the datatype to hyperlink, select the text you want to act as a link and press...

I was using VBA but I had to create a seperate module for each report, and there's over 200! So I created a macro instead and used the CancelEvent action and put it in the On No Data report property. That way when the macro that prints the reprots is running, it'll only print the ones with...

Actually, I'm not using any VBA. Althought I can see why you would think I am. I created a macro (and creatively called it onNoData!) with one action - CancelEvent. I then entered this into the On No Data property for each report. So it will execute the onNoData macro if there are no records...

The macro cancels the report from printing if there is no data in the report to print

Sorry, I did explain myself badly. For arguments sake, lets call the database access1.mdb. It runs make table queries and then prints some reports, the queries create the record source for the reports. This is not the problem. The problem is that half way through running the queries I get...

Please can somebody help me. I have an access database which uses an AutoExec macro to run when it's opened. I runs some queries and then prints some reports. However, when I open it, the macro starts to run as normal, but then I get a windows error message saying it can't find the file and I...

Left(), Mid() & Right() sounds like exactly what I need. can you help me out on it.. what's the syntax???? Yes, I need to split these fields as they're used later on. Thanx!!

They're seperated by a coma in the format last name,first name. However, I also want to do this to a date which is not seperated by anything so how would I go about that. Would it be the exact same? The date is in MMDDYY and I need to split it into MM, DD & YY in 3 different fields. There...

Is it possible to split a field (eg name) into different elements (eg first name, last name etc)? I'm using an update query to update a table from an externamlly linked database (linked table) and need to split a field into individual elements. Can anybody help?

I have some Make Table Querys which are run every day. Is there a piece of code that I can put in to add an extra column which would have today's date in it every day? Thanks for your help

I explained myself badly. It's when I'm putting in the code that I'm getting the out of memory errors. After I've put the code in about 40-50 of the reports, when I go to put it into the rest of them , I start to get the errors. I'm only getting them in access. Every other application runs...

OK, I need help again. I have over 150 Reports and when I pasted the DoCmd.CancelEvent into each one, I started getting out of memroy errors after about 40 of them. Is there any way to create one module which cancels the print each time it's called? Please somebody help me, I don't know what...

It still generated an error. However, when I changed it to DoCmd.CancelEvent it worked. The report won't open now except in design view, but that's not a problem as nobody ever needs to open them - they work off the printed hard copies. Will this cause any other problems for me? It seems to...

That's not working. What am I doing wrong? On the On No Data I entered DoClm.Close but that didn't work. I entered it as an expression also but that didn't work either. What am I doing wrong? Also, seing that not all of these reports will be pringint (once I know where I'm gone wrong!!) Is...

I currently have an Access2000 database with an AutoExec Macro which prints a number of reports every morning so that they're ready for use when employees arrive for work. However, sometimes these reports have no data on them, depending on what was received the day before. Is it possible to...