Search results for query: *

Hi, I wrote a program that watches a number of directories for new file creation. It uses the ReadDirectoryChangesW function to determine this. Occasionally, the function returns error 995. I've looked up its description but was wondering if anyone could provide more information on what is...

Hi everyone, I have a function that run's macro 'X' (and it works correctly and there are no errors when running the application) However, I can not find the macro listed in Access to view/edit. It is not listed under the macro window, nor is it listed as a database component (every other...

I have a question for everyone, what does access do if a user is entering data via forms and then turns the computer off with the power button?

hi everyone I'm working on a research study where researchers need to send data back to our research office from the field. Due to the small scale of the research team, we have decided to use email to transfer our data. I need to encrypt our data before transfer. Does anyone know a good...

hi This may sound dumb but here it goes. I have a form with two subforms. Each subform is on a seperate control tab. Each subform contains interview questions. After all the questions in the first subform are answered, it moves to the second subform to answer those questions. However...

Hi everyone, What is the best way to move the focus between subforms on different control tabs? Thanks dan

hi i have two subforms on a form (they are on different tabs) the user fills out information on the first subform, click on a button 'next' and moves ot the second to fill out more info. I have a button 'previous' on the second subform that i want to bring the user back to the first subform...

hi everyone, I'm working on my first access database and I need to document it for others (I will not be maintaining it). I was wondering if anyone could offer any info on access specific information I should definitly include in the report. Has anyone come across a database devolped by...

Hi everyone, I'm confused with a problem I'm having with one of my forms. When I started the form today, the 'Enter' key will sometimes not exit the current field. It only happens on three of the twenty fields on the form. The 'tab' key will still exit the current field for all fields. On...

Hi all, I have the following code contained in a command button's onclick event *********************************** Dim FinishTime As Date FinishTime = Now ENDTIME = FinishTime INTTIME = DateDiff("n", STTIME, ENDTIME) DoCmd.OpenQuery ("Complete")...

hi everyone, i'm not quite sure if this is the best forum to present this question, but here it goes... I'm exporting data files from an access database into excell 97 worksheets. When access creates the worksheets, I want them to be automatically protected. I'm not really sure where to...

hi everyone, Currently i export some data from my database in excel 97 worksheets. I want to automatically protect them with a password to prevent modification. Is this possible, and if it is, how do I go about doing this? Thanks in advance. Dan

hi everyone I'm a little confused about an error I'm getting code Do.Cmd.OpenForm "Introduction" Me.DataEntry = False DoCmd.GotoControl "IDselectBox" The above code is producing a run-time error '2109' "There is no field named IDselectBox in the current record&quot...

Hi everyone, I want to measure how long it takes to enter data into my forms. At the beginning, i have Forms![Introduction]![STTIME] = Now and at the end i have Forms![Introduction]![ENDTIME] = Now Fomrs![Introduction]![INTTIME] = DateDiff ("n", Forms![Introduction]![ENDTIME]...

Hi everyone I have a table with key CHILDID. I want to be able to enter a CHILDID on a search form, and have the main data entry form open to the record with CHILDID. I'm stuck trying to figure out how to move to the correct record on the main data entry form. Thanks in advance dan

Hi all, I was wondering if it is possible to halt the data entry process and be able to automatically continue it at a later date. My current thoughts are to store the current record and control, and have a macro that will bring them up the next time I start entering data. Am I on the right...