Search results

Good Day All I have what seems to be a simple update query that I cannot get to work. Not sure if it is the newer version of Access or I am just doing something wrong (which is more likely the case LOL). An imported table (new_info) contains random information that needs put into the matching...

Empty Columns / Fields – Normalization Looking for some advice here; I have several tables that have a similar issue that I am not sure really is an issue. I just might be trying to over complicate it. Each table has a primary key and then several “place holders” that may be used. The...

I think I am learning to ask for help well before spending hours on something simple now... Another simple one I am sure... Same form as my previous post with a slightly modified query, query works perfectly outside the form, returns distinct values. When used for the second combo all the...

Hi All Well I cannot believe how much I have forgotten over the years... I have a couple of simple problems that have gotten the best of me. I have read literally hundreds of posts and searched dozens of times; even found the exact issues I am having and I still cannot resolve them... Need to...

Hello All Just getting back into Access after about 7 or so years away... seems I have forgot everything!!! Back to a basic question(s)... I have a Details_Form form based on a query of a single field (Equipment_ID_Number) which is an Indexed (No Duplicates) value (but not the primary key)...

So I have been getting back into this access stuff and poppa smurf has "forced me" :) to go back to basics as you can see from these two threads. http://www.access-programmers.co.uk/...d.php?t=172219 http://www.access-programmers.co.uk/forums/showthread.php?t=172422 In my sample, the question...

Seems to be the week of asking for assistance!!! I had a thread started here which after poppa smurf sorted me out and got me back to basics it is working great!!!! http://www.access-programmers.co.uk/forums/showthread.php?t=172219 WRT to the same set of combos...What I would like to do is is...

I am not sure if I am on the right track with this example... I want to select down (perhaps filter is the better term) to a specific product price. I have completed a series of cascading combos to get me to the "final price" selection, but as you might guess when certain selections are picked...

Hello everybody Just a quick question about security… I have a DB that is FE/BE split with the FE being “visible” and the BE “hidden” in a directory on the server. Access is controlled via the network permissions, etc. Everything is pretty standard; nothing special has worked great for...

I am looking for an easier way to confirm that all a queries that are in a database are being used by the database. I started going through each and every one and it is taking for ever! I have tried the documenter and either I cannot understand it properly or it does not contain the...

Hello All I wish those of you down south or with friends and family there best wishes. I am searching for a way to display an option group (Check Boxes) selection in a report. My example: On a form I have an option group (Check Boxes), lets say “Participate”=(1) and “Did Not Participate”=(2)...

One Time Qry Needed. I am attempting to further normalize a table that I have. Previously I had a check box that indicated that a document was received. As the years go by now, we have started collecting multiple documents and they are all indicated by a check box. I want to move the check...

Hi Everbody Its been awhile so hope all is well. I need some search tips to find threads on automatically updateing the front end when it is opened by a user. I have checked updating, automatic, front end, etc and have not found what I am looking for. Suggestions or links would be great. Thanks

Tonight seems to be the night for questions... I have been reading both from posts and from my reference manuals regarding the requey method. I have a main form FrmRegistration with a text box TxtDOB. I have a subform SFrmAgeCalc with has TxtCurrentAge, TxtDOB and TxtFutureAge. The subform is...

Hello All I have a series of cascading combos on a form that works great. Now I have a main form with some tab sheets that I want to use my cascading combos (now a subform) on and I get an error. Should I be referencing the tabsheet or the main form name in my Row Source of my Combo...

Hi Everybody I am looking for some suggestions on splitting a table up for lookup purposes. I tried the table analyzer but it did not make sense to what I wanted to do. What I have right now is one table with about 200 records. The field are: Tbl-Events EventNumber (PK) Number Divisions...

Hi All I have tried my first attempt at making some tabbed subforms and I have come up with an error that I cannot seem to put my finger on. The error states “The changes that you requested to the table were not successful because they would create duplicate values in the index, primary key or...

Hi All Good to back after a bit of a break... I am at a place where I have put together a small database and tried to implement the no scrolling mouse used from the various posts. Needless to say I did not have any luck... I kept getting the error missing VBA332.dll. I found this link...

I am using the qry below to determine someone's birthday, and it works good from my standpoint although it is not as elaborate as some of the other B-Day code I have seen in this forum. SELECT Year([DOB]) AS [DOB Year], Month([DOB]) AS [DOB Month], Day([DOB]) AS [DOB Day]...

What do you prefer? When designing forms for things like employee data (Surname, address, emergency contact, qualifications, medical, etc) do you: 1. Have one form to enter all the data on; 2. Use separate forms; 3. Use one form with several tabs; 4. Others? Just looking for some ideas as I...