Search results

Same Problem I, too, am receiving the same error message. I have figured out that there is a limitation to the number/size of the Validation Rules and/or Text. I was given a DB to finalize, I did not design nor build, and I noticed it had no error checking for data entry, so I have been...

Thanks Bob, I ran a quick search earlier and did not find that link. I have it now and will look at, if I get time this weekend. Just from skimming across the two pages of posts on that link I am sure this will help me to understand this process. Thank you for all your help. Scot

Thank you dfenton, as I mentioned, I knew I was doing this wrong, but I have no other direction as to how I should do this except for what I can garner here and at other helpful forums. Again, thank you for your time. Scot

Good afternoon, I searched for answers to this within this forum, and while the problem has been presented previously no one had any responses. So, I'll give it a go and have faith someone can point me in the right direction. I have a replicated database across a server network, so that I can...

Open .ldb file after Access is closed With reference to: GHUDSON: "...The .ldb file will not disapear if the last user does not have delete rights to the directory that the db is located in...." I have a user who is performing some data entry on a db on a server that they do not have "delete"...

Yeah, I had clicked off everything on the original DB in the StartUp once I passed it on to the user (prevents them from getting inside, since they don't know the "Control" Key at startup) and now I am modifying a copy as a template for another project. It was driving me bananas trying to test...

Ok, I 1) Added the code: DoCmd.SetWarnings (-1) Which turns the SetWarnings properties on. 2) Checked the Tools/Startup checkbox "Allow Special Keys" 3) Closed the program and restarted One of those worked. But, I am unsure what I did for the program to run through the breakpoints in the...

I am running into this same problem. I am modifying a program and want to test a control. The code runs through, ignoring the breakpoints. What may be causing this?

Yeah, I'm not even going near changing my system settings for one date value in a data entry form.

You bring up a good point, but I don't want to run the risk of creating a bigger problem to solve this one. Also, because most of the programs I build are for research in the US and I am in the US I have the date format in Windows set to US. I just want to override those settings for this...

Thanks for your reply. Again this issue, flipping the inputted date, is for those dates, only, where the day value is 12 or less. Otherwise, the date data is fine. I have the input mask set as you specified, however, it still flips those dates. One note, when looking at the data in the table, in...

Hi, I am creating a data entry program for data being collected from Bangalore, India. My problem is the date formats in India are "DD/MM/YYYY" as opposed to the US format of "MM/DD/YYYY". When I apply the dd/mm/yyyy format to my table design and also to the text box on the form, the format...

Hi, I am trying to populate a field "FN" within a table called "tblFN" with a list of .pdf filenames in the folder "C:\My Documents\Taiwan Cases\" The Access Db name is "TestPopulateCode.mdb" Can anyone assist me in the VBA code to programatically populate that field with the .pdf files from...

Can this be used in a macro? I have a merge utility that I have created for a couple of data entry dbs. When my data entry peeps finish for the day I have them click the transfer (merge) data button on their Db menu form and viola their data is transferred and merged to a main Db on the server...

Can this be used in a macro? I have a merge utility that I have created for a couple of data entry dbs. When my data entry peeps finish for the day I have them click the transfer (merge) data button on their Db menu form and viola their data is transferred and merged to a main Db on the server...

Very nice, thanks Sergeant!

I have a survey DB with many forms, several of these have tabs. If for some reason there was a cutoff in the survey I save the form name and question name (which is always the first Ques on any form, or the tabctl value) into FormSE and QueS, respectively, so I can return directly to that spot...

actually all I need I think is : me.whateverfieldyouwant=me.page3.caption It should pull what ever caption from the tab that has focus correct? I'll play with it and see. If so then I don't have to run through the quasi select case mode. of course that would work too. That's the beauty (and...

Ahh, i see (said the blind man). With that I can then force the page name based upon the tab value. Or, is there a way for me to call the caption of the tab with focus? I am asking because I use the name in a dialogue box elsewhere and the tab index would sail over the user's head. If not that's...

Hey Ruralguy! what is the Chr(34)?