Wizards Lost Their Magic
Jun 22, 2005My Wizards stop working.
Any Clues?
ADVERTISEMENT
Magic Query Needed To Isolate Non-matches
Nov 5, 2007I have a table from an excel sheet that comes in the format above with up to 5000 rows in record groups from 1 to 10 rows in each. The repeating data is how it comes from our all singing and dancing case recording software and I can’t change that fact.
Take a group of records with the same TradingName such as “The Herriots” group, There should be one row in the group where FdInspAction = LastInspDate (in this case 06/01/2007) . In this group there is no match so we need to identify the group. The “Bloggs” group is fine (see Row 8) so can be ignored.
My feeling is it can’t be done other than by visual checking. Can anyone think of a way around this?
IDTradingNameFdInspAction LastInspDate
1The Heriotts 03/02/2001 06/01/2007
2The Heriotts 10/02/2002 06/01/2007
3The Heriotts 16/02/2003 06/01/2007
4The Heriotts 25/01/2005 06/01/2007
5The Heriotts 04/01/2006 06/01/2007
7Bloggs Ltd 02/01/2005 25/01/2005
8Bloggs Ltd 25/01/2005 25/01/2005
Wizards
Jul 28, 2006I have never used wizards with access (or anything else for that matter). What is general view? Are they actually good news or do they get binned with witches and warlocks? I could use some of the techniques involved but where does one find an intro - preferably using access.
View 2 Replies View RelatedNo Field Selection Available In Wizards
Mar 23, 2007I'm somewhat new to Access, so I'm using the wizards to get me started to make forms and reports.
When you first click on the "Create Form by Using Wizard" it asks you to select the fields you want to use from the selected Table or Query. Unfortunately no fields show in the "Available fields" box.
I know I have fields in each table or query. I even tried to make a dummy table using their field names incase mine contained invalid characters.
I've tried it in both the Form wizard and the Report wizard.
The fields of all the tables and queries used to show up when I first install Access.
What am I doing wrong? Should I try to reinstall the program?
Thank you for your help,
Pam
ToolBox Wizards Not Working
May 16, 2006I have microsoft access 2003
Everytime i select tool box and chose example combo box or option group
none of the wizards are working just place it on the form
I uninstalled and reinstalled it but still the wizards in the tool box dosnt work
Last thing i was working on was a switchboard but deleted table and form.
Please help.
Error: There Are No Registered Wizards Of This Type...
Oct 18, 2005In Microsoft Access 2000 I'm getting the following error message when I click on visual basic Event Procedure for the first time.
"There are no registered wizards of this type."
"Rerun Microsoft Access or Microsoft Office Setup to reinstall the wizards. If you want to preserve your security or custom settings, back up the 'workgrp file name here' workgroup information file.
For more information on backing up files, search the Microsoft Windows Help Index for 'backing up files'."
After I click OK on the error it goes back to Access. If I click the event procedure again visual basic opens up though VB the screen isn't what it suppose to be. The Object and Procedure pull downs at the top of the page disappear behind my toolbars and I can't get it to setup correctly. If I try to maneuver them correctly they still don't line up. This error seems to be messing that screen up.
This is only happening in one of my databases. In my other database the Object and Procedure pull downs at the top of the page are coming up correctly. If I start a new database that works fine too. I'm not sure why its doing it only on this database
I'm worried my VB is corrupted. Looking for any insight on what caused this and how to fix this.
Thanks!
Command Button Wizards Are Disappeared
Dec 7, 2013i am using MS Access 2010, i am on initial stage and i have to made main log in form or switch board, but as soon i create a blank form and click on button in design but only command button appeared but not along with command buttong wizards so i will select button to close application or to open a farm and so
View 1 Replies View RelatedWizards Do Not Work Under XP For Users With Restricted Security
Jan 26, 2006The problem occurs on a WinXP machine with Access 97.
When Access is run as a Power User everything works fine but when it runs under a user account that is a standard "User" non of the wizards function properly.
By changing some file permissions I can get the control, form and report wizards to work but the Import Data wizard still fails.
I'm sure this is a permissions issue and can be fixed by changing the security settings for some registry keys or files, but have no idea which ones.
Thanks in advance for any help.
Lost A Dll?
Jun 21, 2007i have just had a problem
if i try to edit an open form by clicking the design icon, i get a message
cant find the call back function or macro "fdesign". ican still close the form and open it from the dbs window
this is affecting accessXP and access20003, but not A97
ive tried repairing/reinstalling the XP installation (but not the 2003 yet), but this has not fixed it.
Any thoughts?
I'm Lost
May 23, 2007I have a table and it has:
namefield
surnamefield
state1
state2
state3
match(Y or No)
importDate
I would like to make a query+ report so that in the report it looks like this:
<<Name>> <<Surname>>
<<state1>> <match>
<<state2>> <match>
<<state3>> <match>
in one line, at the moment I made a query and the name shows 3 times...
can anyone here give me some hints how to show the name once + the match. Thanks in advance
Cheers...
Lost And Need HELP!
Sep 26, 2007I am new to using MS Access and am already frustrated that a simple task is getting the better of me.
My situation is that I work for a company that has a number of reps, which are allocated their own ticket books(block). Each book is 50 tickets in size i.e say from number 320500 to 320549. All tickets are entered through our internal system for whatever the ticket was used for.
Now here is my problem. Each block is registered to an individual rep which we need to keep record of as to which tickets are allocated to them, other then having to enter each ticket individually into our ticket block records system, I am trying to make a database entry that accepts the reps name, ticket block start number and then automatically adds the next 50 tickets to that rep, so when we use a search field on any ticket it displays the rep that the ticket was allocated too.
In my head i'm looking for the MS Access way of doing the following:
[tickblockstart]+1 until [ticketblockstart] = [ticketblockstart]+50
Can anyone help me with this probably very easy problem, that i can not seem to grasp at the present time.
Regards
2rsGarry
Im Lost!
Nov 16, 2005hiya, im trying to create a button my form that will move all 'finished' records from where they presently are, to another table.
the button does work, it moves the records into the 'new' table, however it does not DELETE them from the table i moved them from, so now the records are stored in two tables??
the code i have is as follows:
SELECT * INTO Table2
FROM Table1
WHERE Finished='Yes';
if there is something different that i should be doing, or a better way to do this move, please let me know.
(also if this is in the wrong section feel free to move it)
thanks!
I've Lost Myself
Nov 2, 2006:confused: Fingers crossed I'll get some direction to resolve an issue that I can't even begin to imagine how to search for.My database is used to record detailed work done with clients who are receiving regular support. I'm designing it around a Common Assessment Support Framework that I have no choice but to follow, except for some minor points. There is the potential for approximately 40 different assessments for each client and therefore a lot of duplication in personal details.So far this forum has been a great help and I have learned a lot from those who volunteer their time to those of us who need it from time to time.Following the numerous examples of normalisation posts I have attempted to ensure there is no duplication of information across tables. I've come to a point however where I am stuck:The end result of what I am trying to do is create an individual report called Needs Assessment Planning Tool - rptNAPT.The report will be populated from the fields in qryNAPT that is made up from tblIA1 and tblIA2tblIA1 consists of 17 x 'area of need' that is broken down in to 5 elements: 'Now - Y/N', 'Later - Y/N', 'User Level - Number', 'Worker Level - Number' and 'Disagreement - Memo'. These fields are entered by using frmIA1, and these fields are entered by using frmIA2.So, now I have to enter data in to another form; frmNAPT that includes both theseand thesefields. I only need to show the area of need where Now is True in the form and the subsequent report; rptNAPT.My thoughts about this are (please don't laugh) in the form frmNAPT the 'Area of Need' because in the table there are 17 different areas e.g. Accommodation (improvement), Homelessness, DomesticViolence etc will need to be unbound and in some way filtered to show only those area of need where fldNow is True? and fldUserLevel is NotNull or doesn't equal zero. I will need a minimum of five such fields to show the Areas of Need that the Client and Worker may elect to work on.Sorry for the long post but I'd really appreciate some direction on this, even if it is only to point me in the direction of a link that can be helpful.RegardsDoug
View 5 Replies View RelatedLost Passwords
Jun 22, 2005I created a DB in an old PC of mine for a customer. I set passwords for user accounts to prevent users from accessing the design etc. I bought a new PC lately and I want to open the DB to work in it but I get an error saying that I do not have the rights. I suppose I need to create the same accounts in my new PC as in the old one but I don't remember the username or password that I was using back then. Any Ideas???
View 4 Replies View RelatedLost MDB File
Jul 13, 2005We have lost an MDB file. Is there a log file where command calls to Access are stored so we can try and recreate the database?
View 1 Replies View RelatedLost In My Database...
Jan 19, 2006My database queries, tables, and reports is growing. Is there a function/utility that will show me for a particular report what queries, and tables that are used to gather the data that populates the report?
Thanks!
Gunner...:confused:
Lost My Menu Bar
Apr 24, 2006Greetings,
I have just opened Access and for some reason my menu bar is gone. I have fiddled for a few minutes try to find and restore it - but I am clueless. It is working fine in all other programs.
How do I restore it?
~rbinder
Lost On Security
Jun 19, 2006I'm completely lost on how to get started on security. After reading all these postings I'm more lost then ever. What is a backend and frontend security? How do you create password for each users? etc...
Please help!
FYI I'm using Access 2003
URGENT ... Help Me I'm About To Be Lost
Mar 29, 2008Good morning friends
My database, I don't know what happend to it.
I'm trying to open it but it gives me a message:
"The form name 'Welcome Screen' is misspelled or refers to a form that dosen't exist' If the the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and enter the correct form name."
and then after I click ok it open the database but it doesn't show my forms, Reports, Macros or Modules that I have created before.
what does it mean, may I lost all my previous work and data ??? :(:(:(
Please I'm waiting you ... I'm about to lose my mind
Completly Lost
Jun 19, 2005I have been trying to figure out comboboxes and lookup tables on and off for two weeks now and am completly lost. I have read the tutorial on cascading combos. I have downloaded and studied the the autofill db example from Pat Hartman. I have searched and read the threads and am still having a problem. I have several lookup tables. I will use one as example. This a database for my lawfirm. We get a lot of referrals from other attorneys. I have a lookup table with the name, address and phone of all attorneys. I have a combobox on my clientinfo form that looks up the atty info . I put the attorneyid field in my clientinfo table as FK and linked my clientinfo table to the attorney table thru this field. All this did was generate an error message that I could not save my record because there was no corresponding Atty record. I know this should be so simple. Can someone please help me? What do I with data I have lokked yup from a lookup table and how do I link it to the tables that will need it later on? Thank you in advance.
View 2 Replies View RelatedI'm Completely Lost!
Nov 9, 2005Good afternoon all,
Really struggling with my structure and have been looking at it for so long my head hurts so any advice would be great. (see attached)
Basically, I want a DB for keeping track of service / repair of electronic machines. Many of our customers also call us for tech support. There are a number of other items like purchases but once I have worked out one, I can then copy the methods.
Are my relationships even remotely correct?
I cannot get the calls log to work - loosly based on the sample a supplied with Access "contact managment".
:confused:
Any help / advise would be greatly received
Query... A Little Lost
Mar 24, 2006I have 5 forms and 5 tables.
The database is blank, but the information entered into the forms are saved into the tables.
Now I want to make a query so I can see some statistics regarding the information entered into the forms and stored in the tables.
I have created a query, but Im not sure what to do next, do I connect it to the query and it should give me desired output or do I connect the form to the table
or how does it work ?
need some feedback Im a little bit lost in this :(
regards
Frodo
Lost Query ?
Sep 2, 2006I recently moved by database from one hard drive to another - all is working ok after refreshing the links. However I have a few queries and reports that are date or date/time specific. (ie; I input a specific start / end date or start/end hour) Now when I run these queries it returns an error message stating 'Data type mismatch in criteria expression'
Please does anyone know why and how can I restore the queries ? Prior to the move all queries / reports worked OK.
Best Wishes
Richard
Got/lost Focus Help Please
May 18, 2006Hi there.
I have a form and on open it traps the user into a combo box where an option must be selected before they can move to another field. I did this by using the lost focus event of the combo to check if an option has been selected and then return the cursor to the combo if no selection has been made.
The problem is that there is an exit button on the form which the user must be able to use to exit the form without interacting with it, say if they opened the form by mistake and just wanted to exit immediately.
I cant find a way to trap users into selecting an option from the combo before filling the rest of the form while still allowing the exit button to work. At the minute you still have to select an option in the combo even if you just want to exit the form.
I have been a notes developer for years so I’m still not that familiar with access and the way its events work so this could easily be a gormless question. Feel free to point that out. Any comments would be much appreciated.
Lost My Switchboard
Sep 22, 2006I have a switchboard in a database, and probably made some edits to it along the way. I don't even recall, now. Anyway, when I try to use the 'Switchboard Manager' now, it doesn't even list my switchboard as one of the options. My only choice is to start another one.
Is there a way to register a form as a switchboard, after the manager drops it?
Thanks,
Matt
Totally Lost
Oct 12, 2006Howdy all!
I am sorta new to access (I used to use it about 6 years ago, but haven't latly so relearning everything), and I am trying to build a db to track the different projects I make for my webstore (www.mutzigcreations.com (http://www.mutzigcreations.com).
I am trying to make a form that is tabbed so that I can enter in all my base information (different materials {wood, acyrlic, and specials}, clips, platings, etc..) into my different tables, but for the life of me I can't seem to get anything to work.
I really just want 1 tab per item, so 1 tab for clips that would enable me to enter in all the different clips into my clips table. I can't seem to get a connection of any sort to work and was wondering if anyone had any advice or guidence on what to do?
Thank you!
Doug