Recent content by Shaft

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