Search results

Hey folks, I notice that microsoft access database files can get gigantic very quickly (and reach the max 2 gig file size thereby rendering the database useless at times), and that when the shrink/compact/fix command is used the database becomes a fraction of the original size. I am wondering...

Hi Folks, I am wondering what is the best way to tackle this request and am really not sure. I am trying to determine the number of what I call flip flop interations. An individual can be in group a or group b at any given time, but for each day of service on record must be in at least one of...

Hi Folks, I have created a file sweeping program in Microsoft Access via VBA in a few modules. The program simply reads certain files in certain directories, and determines if, when, and where to copy those files based on certain user inputs. One of the features I would like to add would be...

Hello, I am just starting out with some very basic web design and a bit lost. Can anyone tell me how, or point me to the right resources ... I am trying to simply place an input box on a webpage along with a button. That stuff I have already done. However, what I am trying to do is somehow...

Hi Folks, I am wondering if it is possible to execute a DTS package via Microsoft Access. I have done a bit of research and cannot seem to really find anything that claims this is possible or how to go about to get it to work. I am running SQL Server 2000 which has quite a few DTS packages...

Hello, In an attempt to automate routine data entry for a non-profit government agency, I have created a series of several Microsoft Word templates (.dot) which enable the user to enter information only in certain fields (greyed out text boxes) and the rest of the document is protected. This...

Hi Folks, I am attempting to automate a manual process for a non-profit agency. Submissions come in as text files with a 5 digit extension being the julian date of the week of submission. For example, a file might be named ah7740932.01506 where the extension 01506 would indicate the julian...

Hi Folks, I am creating an IF CASE statement in SQL that basically takes the 2 last characters in a field and if they happen to be 'HX' then a special rate is used to calculate the cost whereas if their is no 'HX' as the last 2 characters of the field then a different rate is applied...

Hi Folks, I am attempting to split out a descriptive field so that each words which may exist in that particular field will be split out into seperate fields ... for example, if the violation field is populated with a four worded description of 'Assualt on Police Officer' I would like to...

Hi folks, I built a access 2000 database years ago as a front end to sql server 7.0 and it has been working well for quite some time. Last week, I upgraded sql server 7.0 to sql server 2000 and had no problems for the first few days. Now all of a sudden, whenever an individual uses the...

Hi Folks, I am wondering if someone can help me determine someway to setup a microsoft access database that I have so that the user can do nothing at all besides using the input form that I created and that automatically opens and is maximized via the autoexec macro. The reason for this is...

Hi Folks, I am wondering if someone can help me determine someway to setup a microsoft access database that I have so that the user can do nothing at all besides using the input form that I created and that automatically opens and is maximized via the autoexec macro. The reason for this is...

Hi Folks, I have a form which loads when a microsoft access database is opened for some simple data entry. The form has some code which hides or unhides certain needed or un-needed fields depending on the type of record being entered. The type of record is determined by a drop down box field...

Hi Folks, I know this is possible, just not sure how to proceed or what function to use ... I have a normalized database of unique identifiers, admit data, and discharge date. I am attempted to count only the dates within a certain range between admit and discharge dates for each record. For...

Hi folks, Just wondering if it is possible to populate a database by scanning in a form into a scanner? For instance, if I had a standard paper form with typed data inside of the paper form's fields, to place that form into a scanner and have a program extract the characters in each one of the...

Don't want user to bypass Thanks Chris ... I tried that and it works perfectly but only if I use the save button. Is there a way to force the user to use the save button as oppossed to the user just hitting the 'tab' key which bypasses clicking on the save button and just saves the record and...

Hi Folks, I am creating a database where a user enters data via a form, and depending on what value that user select from a certain drop-down box, different values become mandatory. I wrote a code which works perfectly as to alerting the user of requried required; however, how would I not only...

Hi Folks, As a step in getting to my end result, I am trying to take a database that has a beginning date and ending date fields. For example, the first record might have a unique record key of 111, a beginning date field value of 7/1/03, and a ending date field of 7/5/03. Is it possible to...

Hi Folks, The following problem that I am working on for a non-profit government agency has unfortunetly surpassing my coding skills. Any help would be GREATLY appreciated, as I am frantically trying to find out how to do this ... I know it is possible, just not sure how to go about it...

Hi Folks, I have a form that has a listbox as one of its items. The listbox has 4 values and is a required field. If the very first value of the listbox is selected, I would like to somehow make 2 other fields on the form non-mandatory and grey them out because there would not be enough...