Search results

KeithG - But I still need it to automatically advance the day at 11:00 am every day as well. How do I write that into it?

I know I am asking for a lot now, but is there a way to make it only for dates Monday thru Friday?

ghudson - thank you for your help. I have learned to always make backups when changing or trying something new.

selenau837 - thanks for your response. My DB jumped from 17 mb to 388 mb and I have run into all kinds of errors today and I am working on fixing them right now.

Gents I hope you can help me with this issue. If my BE DB crashes I use compact/repair and it fixes the problem. If I Just use compact/repair on my BE DB when nothing is wrong with it then it causes the data to disappear in certain fields. Any Ideas what i am doing wrong. (Besides from...

RG - That is what I am looking for. If you have time can you break that down for me as to what ("h", 13, now())) means. "h" means Hour, right 13 is = to 1pm So the date will change every day at 1300??? What is timeit going off of? Is it the time on the individuals' computer? Once again you...

I am just trying to do it in just the form.

KeithG - thanks for the response, but you have lost me. I have startup form but how do I put it on a timer and then how to I write it look at that timer. will this slow down my forms/data entry?

I have search for an answer on this question. What I am trying to do is set the default value =Date() until 11:00am and then I want the date to covert to the next day. Can anyone please help me with this or is this even possible?

Thanks for the help neileg.

If I place this in my BE this will tell me who is in my Database on the network at all times?

Neileg - how I do this? Or please point me to material that can help me do this. The other question I have is that when I put [Enter Date mm/dd/yyyy] in in two different criterias and try to export to a .txt file I get a "too few perimeters. expected 1" error. Here is my code: SELECT...

You need a FE/BE. Go into your current DB that you got and goto Tool>Database Utilities>Database Splitter. It will do it for you and now you have a FE with your forms that automatically links your tables in the BE. I hope this helps and is what you are looking for.

Gents I have my tables set up with the Short date in the table. I know this might fall into the query catagory but it also has to do with the tables, so I am not sure where to put it. Problem: I run a query on the date and when I export that to a .txt (Fixed Length) file it pulls in the Time...

Get everyone out of the production DB. Delete the forms, queries, etc that you want to changed in the production DB. Then import all the changes from your copy on your hard drive. or if it is FE only Just replace it when everyone is out of the production. I don't know if you have security on...

Len - you are awesome, thanks for the how-to paper. You should post that somewhere for anyone trying to do security can search for it. One flaw I did fine was in the shortcuts, but I was able to figure that one out..... Once again thanks a million. Craig

Use a query to bring the tables together and set the form to open to a new record. If you look at the Doc I have attached. Top portion is tblMBRinfo Bottom portion is tblClaims. If I type the SSN in the botoom the rest of the info is populated for that MBR and then I just enter the new claim...

Thank you. PM sent.

I have looked and searched everywhere, if some could point me to a link that will walk me step by step on how to setup the security on the DB I would greatly appreciate it. I have look at the following link...

Kempes - I tried your idea but changing for a text box and what you type triggers the info in a combo box. Some how I am not getting the result that I want. I have come close but with a text box there isn't a row source. Help please. I figured it out. thanks....