Search results

Hi Have searched but not really found anything that fits my needs ! I have access2003 DB that contains a lot vital information, but is still work in progress/Use, so don't want to split it yet Now the problem, I would like it on exit to autobackup the DB to another PC on the network. I would...

thank you Pat - thanks for your help, I just changed the table to make the fields required. I will be honest the rest just went over my head - you are right I do tend to treat VB as macro's - but I am still learning (this DB is my first using VB). However I am still for some reason it still...

Sorry !! Guys, sorry should have looked around a bit more before posting - have changed the form to data entry= yes, this seems to have cured the problem, however now getting blank record instead - this does not seem to cause any problems but is a bit untidy, any suggestions??? also still...

Hi, I found while testing this database before letting my users at it, after a couple of months work off and on. The problem: This data base is a holiday and absence control database and the problem is when I have entered a absence in a form using the code below to generate the records for...

Thank you Brianwarnock, Thank you - again this forum, has got me out of the s**t Did not know you could not call a table in the criteria - so would have never got the syntax right!! Your solution worked fine once I removed my typo's Regards Dean

Hi, This is something simple, and I think it is my syntax that is wrong I am building a holiday database that will be used for more than 1 year and want to produce reports only for the current Holiday year. My method of doing this is to have a table that contains ALL holiday data and use a...

jgrayek your amendment worked perfectly - thank you I am now starting to understand how Dlookup works in VB (very slowly !!) I am so used to the excel way of doing things, it takes a while to get your head round something new. Thank you to every one who replied to this post and hopefuly I...

more help with a dlookup this soooo frustrating now using a lookup to check if a date is bank holiday and back at the same problem Code Snippet: 'checks for weekends If Weekday(counter, vbMonday) = 6 Then counter = counter ElseIf Weekday(counter, vbMonday) = 7 Then counter...

thank you llkhoutx llkhoutx, thank you that worked perfectly - maybe a little more help if i may ask - I am a experienced user of excel and have used lookups a lot. any chance of explaining to me how that statment worked so I don't get stuck again, if you have not got time it is no problem and...

hi, this is driving me nuts I have looked everywhere for a solution and it should work but dosn't !! I have a form used to book holidays into a database, The driveres name is supplied from a conmo box and then I want the depot filled in automatically from a lookup from a table containing...

done it !!!!! boblarson - you are my hero !!!! that was the problem - I re wrote the macro in VB and put it in the script instead of running import2 - the import worked fine (and a lot quicker !) but excel was still open afterwards :-( , so I then removed the lines to open and close excel...

Hi, i am running a script from a button is pressed to import 36,000 records from an excel spreadsheet - that works fine, however I can not get excel to close completly when finished - i have searched the forum and the internet I havetried different bits of code but none seem to work,open...

Thanks Thank you Seth that worked - I copied the on timer from elsewhere and should have checked when added the extra bits Thanks again Dean :)

Can anyone help ? I have this Code running when a form opens to import and update a table from excel - I will be the first to admit I am no expert but the bits run ok when not put in one script - but it keeps opening excel again and again when put together instead of just once. I "borrowed"...

Guys, Thanks for your help but neither method did what I was after - so attacked the problem from a different angle and used my very scant knowledge of VB to do the task and eventually got there but narrowed the choices first - but thank you for everybodies help anyway Dean

2 answers What I have is a list of Absence types - Week Hol, Day Hol, Sick, Training, Etc, Etc, - What I am trying to achieve is If the "All Holidays" is selected the records with either "week hol" or "Day Hol" will be selected or it can be filtered by "week Hol" or "Day Hol" singulary from the...

First Post - please be gentle :) I may be missing something here, but can any one help? I am using a Iif statment in a query to filter records as follows: If([value from a form]= "all holidays",("weeks hols" or "days hols"),"not a holiday") This is returning a to complex to calculate error...