Search results

Sorry for the delay in replying it's been a bank holiday weekend only back in work today. I'll try and explain in more detail what I'm trying to do. I'm making a wages database, and on the timesheet form I've got the timesheet in a subform and the wage critera on the Main form and I want to do...

Hi All, Could somebody tell me how to reference each individual record in a datasheet or should I populate a recordset with the same results and use that instead. Any help would be much appriciated, thank you

Hi All, I've developed a database that was working fine until I split it to use in a network enviroment. The problem is a make-table query that now make it's table in the front end instead of the back-end. I need to run a make-table query because the query uses a custom function which then...

Thinking outside the box I like it, thank you. Oh yeah the response table is for the questionaire answers. Cheers

Hi All, I've made a questionaire database as shown in the attached picture. My problem is I've got the same questions on multiple questionaires and don't want to duplicate the questions in the questions table for each questionaire. Any suggestion would be greatly appreicated. Thank You

Hi All, I've managed to get round the problem by setting the default value at table level but this would be unsatisfactory for a lot cases. Very frustrating:mad:

Hi All, I've been searching the internet for the resolution but all I've come across is somebody else with the same problem. He explains the problem a bit better then me so heres what he wrote

Hi All, I've made a data access page which is in data entry mode. One of the fields is a date field which I have set the default value as =Date(), but it only inserts the default value when you move to a new record it doesn't put it in on the initial record. Any ideas? Cheers

Use chr(13) to get a line feed. Good luck

Hi All, I'm creating a Holiday Authorising database and I'm stuck, I've created a query that checks to see if any authorised holiday falls during the period of the unauthorised holiday and if they do I've written a vb function that returns the dates that match as a comma-delimited string. The...

Yeah good thinking. Thank you very much :D

Hi All, Can anybody tell me whether it is possible to use a global variable defined in a vb module as part of the criterea in a query, if not whether there is a work around. I suppose I could temporarily write the data to a table and use it from there, I thought there would be less messing...

Your a life saver RuralGuy that is just what I'm looking, Thank You, Thank You, Thank you :D ,you've saved me so much time. Cheers to everybody else for there input as well. It's back to the grind stone for me.

I've been searching everywhere and can't find one that can display text on a particular day. All the ones I've found refered to on this this site are little calendars with no scheduling options apart from circling or highlighting a day. What I want my calendar to do is to display the names of...

There's nothing there that really fits the bill, cos I need to schedule event on my calendar. Cheers anyway

Hi All, Does anyone know of a good free calendar object that I can dynamically add text too, for a holiday planning database I'm making. Thank You

Hi All, Just a quick enquiry if I sort a query by a date field in ascending order then select unique records will I get the latest records. Thank You

How's that going to work cos I only want to count the 0's the 1's or 2's at any one time. So if I count them all it's going to tell me nothing. Each column is a question and each row is a questionaire.

Hi All, I've created a table that take the results of a questionaire, with 0 = No 1 = Yes 2 = N/A For each question I want to count the number of Yes, No and N/A in one query. I can get the result for one question by using Count with the critera set to = 0 or =1 or =2, but can't do it for...

HI All, I've designed a report, which is basically a main report Which there is always data for then a page break then a subreport, so each subreport is on a new page. Which works fine when there's data for the subreport, but when there is no data it prints a blank page. How can I fix this...