Search results

maybe you could check out my DB

What the problem seems to be is in the toaldays textbox I have this statement to count the number of days between two dates. =IIf(IsNull([Day]) Or IsNull([DayTo]),1,funWorkDaysDifference([Day],[DayTo])) If I take this out of the control source it works fine but if not I get the error

You can put it on any network drive that the users can access. Just make sure the database isnt open in exclusive mode. To do this use the File > Open method and browse for the DB and when you find it before you open make sure the check box Exclusive is not checked

I think what you are asking is where to put the db correct? You can put it anywhere the users will be able to access it. Make sure they have permissions to the folder it is in also.

thanks for the try but it give me error 2108. I need to save first. Any ideas?

cool Thanks for the Info!

So should that be all wrapped in " " ?

What is the difference between SELECT * FROM Persons WHERE LastName = 'Majewski'; and SELECT * FROM Persons WHERE LastName = "Majewski"; When will you run into trouble switching the single and double quotes? Or will I not run into trouble

Those tutorials actually make me actually understand SQL! Thanks So Much!

Wow that looks awesome! thanks soooo much for all your help and everyone else help on every project you have helped me on.:)

I will be changing jobs in a few weeks which could in turn result in me using more sophisicated databases. I will have to pull data from other packages other than Access, using SQL. I will be using Crystal Reports. So hopefully the knowledge I learned here will help me in my future endeavors...

cool thanks Ill take a look!

how would I change that command to check if the check box is checked and insert ".5" into the "totalDays" textbox?

...but where do you find those names?

So how do you learn what commands are available to use and where do you look?

thanks Mile! You da man!

mission, Where do you find those commands like EmailSend.ReadReceiptRequested=True 'receipt request I mean where do you look for references or do you just remember everything off the top of you head?

I have a table that stores beginning vacation and ending holiday date. I use =IIf(IsNull([Day]) Or IsNull([DayTo]),1,funWorkDaysDifference([Day],[DayTo])) to get the work days between the dates. I used to manually enter how many days was between those dates but after I found that formula I...

try one of these free set up packages http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47118&highlight=installation Should do what you need. Setup2Go seems the best

no with the current setup. You can split the db into a front end and back end and create a seperate front end for each person using the DB and have their respective version on their own machine