Hi all, I have a macro to transfer the results of a query on one form to another form. I have it repeating the macro to equal the number of records displayed...
Hi again. Worked around my problem by adding a "end of file" record, so it is the last one selected becomes the one missed in the transfer. Not a good fix but...
May be the simplest solution is to make two kinds of countries : those with Country/State/Town and those with only Country/Town. Use a true/false field in...
Hello All, I have a 7 drop downs that select from a table for a performance evaluations. the user selects from the drop down and each value in the drop down is...
Jim, The is a small issue with the formula structure, Lets assume you pass the value of 1 in [txtAverageOfAllNumbers]; as per the formula it should and will...
Biruma, I did not think of going from upper to lower. I tried your expression but gave me the name error. The i changes to an [i]. I tried to remove the i...
You need to replace the "i" with [txtAverageOfAllNumbers] or whatever you are using to store the average number ... From: Jim Wagner <luvmymelody@...> ...
Wanted Spell Checker Shell Application I need to develop a custom spell checker for a database application. The area is a specialized technical domain and...
You can use the spellcheck info from ms word. create a db file & run it against the text in the database ... From: boddhishaman <nowatzke60130@...> ...
Hi all, I have a split database that for some reason runs slow or pauses if more than two are using it. The settings are the same as several others that work...
check the format of the data fields.. If you are looking for an exact match, there might be a hidden character or space that will not sow up in the query ... ...
... records< No. I am trying to create a query to eliminate blank fields in a column. There are close to 14,000 entries, 6070 are blank (when using a filter). ...
Brad This may sound silly or I have missed a posting ......But, is it possible that you have spaces in the "empty" fields....??? This will appear to your sql...
... This will appear to your sql as a field that is NOT empty.< Wouldn't that also be the case when filtering for an empty field? I checked several of the...
WEB/DB Application Programmer for national cable service company ************************************************************* *** Please send all replies and...
I have an Access File that I would like to distribute to people who do not have MS Access on there computer. Does anyone know what is required? What are the...
Access 2000, Developers edition, was supplied with a runtime module and a licence to install this with databases on other computers. I'n not aware that there...
What you are talking about in Access is the distributed file, an MDE. This file can be given to someone that does not have access and they can run the...
FULL TIME ENTRY LEVEL WEB/DB APP PROGRAMMER POSITION ************************************************************* *** Please send all replies and resumes to...
Is there a way in a query to pull the worsheet function percentile? I am working with a table of salary data and just need the 25th, 50th and 75th percentile...
Hello folks, I want to create a search form in MS Access 2003 where the user enters a ID in a unbound text box. There is a search button provided. Once the...
I have a search screen in MS Access 2003, with a unbound text box to put in the parameter to search. I need to have all the text boxes in the columnar display...
Peter I'm not sure if what you wrote is really true. I think an MDE file will still need MS Access to be installed on the computer for the MDE to run. However,...
Dear group members, I have a form with two controls named ctrl_1 and ctrl_2. 1) I wish ctrl_2 will be invisible when the form is loaded(opened?) 2) I wish when...
Look into the on_current property, and the visible property. Psuedo code to foolow: Control_1 on_current If me.value = 10 then   control_2.visible = true ...