Does anyone know how complicated would it be too allow the user to key in the first couple letters of the last name in the combo box & have the combo box prompt names that begin with those letters?
I thought I did this before, but I can't figure out how.
I would appreciate any advice.
hey guys
I have a query that ask for an input. I was wondering if there is any way to make the prompt have a combo list, so the users can scroll and select the input ,which will generate the Query results,instead of having to type the input in.
will really appreciate your help.
:confused: I would like to create a popup on my combo box to do the following:
When a serial number is entered and no records are found, it prompts "no matching record/s available" and no controls show data.
Currently, if I enter a serial and no data is found, the control options stay with the current data which doesn't match the serial. Users can't decipher if the search worked.
Any help is greatly appreciated. Thank you all for your expertise!
http://www.bcwwrestling.btinternet.co.uk/pirce_band_func_deps.jpg
I have table with the functional dependencies shown above.
I would like to know if it is in 3rd Normal Form. I think it is.
The table stores data on DVDs and Tapes.
Format = "Tape" or "DVD".
Region is either "1","2","3" or "0" (If format is DVD)
or "PAL" or "NTSC" (If format is Tape).
Rarity is a rating (1 to 5) of how rare a tape or dvd is. The user uses their descretion when deciding this value, but the take format and region into account when deciding.
Price is the cost of the tape or dvd. The rarity, region, and format are considered when the user decides upon a price.
Region, rarity and format are unique, and can only appear once in the table.
Finally, Price band is the primary key of the table. It is a value used solely to identify the combination of Format, region and rarity.
Im not sure if I have done the diagram correctly. Im not sure if I need to model a dependency if it is only there because the user is using data when deciding on the value of other data.
In which case, would this be the correct diagram, and is it in 3NF?
http://www.bcwwrestling.btinternet.co.uk/pirce_band_func_deps2.jpg
I have a form with a textbox and a button. When the user enters in a number range, I need records to show up for only dates that are in-between and/or equal to the numbers typed in the textbox.
For example when the user types in 4-9, and pushes the button, a display of records will be displayed for only 4, 5, 6, 7, 8, 9 (if there are such records). The numbers are contained in a NUMBER field of a larger table.
This seems to be a tough question, and I've done days of research on it and can't find an answer.
Hello everyone. This is my first post (for not asking help :) )
I look at topics for start up options etc and I think all of this it’s ok but there is a smarmiest way to start your application. So here we go..
We make a vbs Script
Set WSHShell = CreateObject("WScript.Shell")
WSHShell.Run """C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE""/RUNTIME ""C:Documents and SettingsEvalDesktopDataBaseUI.mdb"""
And we start The Access In runtime and open your Db
Note this working with Access 2003 .If you have an other version just change the access directory “C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE”
Where is your Office Access
Then you can make a shortcut of your .vbs script and rename it ass you like
You’re Application Name. You can change the Icon (If you have a Program File’s Folder Place your icon) Right Click Properties/Change Icon
Then your app is starting in Access /Runtime and everything is fine :)
Access 2007-2010 format Form, 9 bound fields, grouped together Smart Tag = "UnitGroup"
Summary: Needing to run VBA whenever the value is changed within one (or more) of these fields. User could be placing new value (defaults at 0) or editing(changing) previous value entered.
I am not good on writing loops/next statements. But I am wanting to make an image visible to true when someone changes the value within the group.
This is what I have so far:
Dim ctlGroup as Control
For Each ctlGroup in Me.Controls
If ctlGroup.Tag = "UnitGroup" Then 'finds the smart tagged controls
If ctlGroup Then 'if any fields within group changes value then
Me.Image321.Visible = True 'show image
End if
End If
Next ctlGroup
I don't even know if I am close with my code - clearly it is not complete and lots of holes of wonderment!! Maybe it would be easier just to use the individual even (on change) with each individual field (9).
I have an Access template I downloaded which has smart tags. I want to remove all smart tags all of the forms but how.
It must remove all tags as other users will be using the same database on different pc's. So mustn't be a local client setting.
I am operating in MS Access 2007 and unfortunately have to stick with the "out of the box" controls. I have data entries of notes in my database for "most workdays" - but not holidays or weekends. I want to allow the user to be able to edit notes for "most workdays" - but not let them pick a day to edit that doesn't have notes - by selecting them from a calendar date picker. Essentially, I want to gray-out/lock the non-workdays from editing.Is there a smart enough Active X or other control as a Date Picker that uses the results of a query to show valid/invalid dates?
View 2 Replies View RelatedWe are looking for an access based software similar to this http://www.pedyn.com/access/P2000details.htm
Could any of you can guide us to get a best suit
After I do a "DoCmd.RunSQL "Update ..."" I am asked if I really want to perform the 'Update'. Does anyone know if there is a way to get rid of the prompt and just carry out the query?
Thanks
I have noticed that when i am editing an object within my database, specifically a query and click to close it, it doesn't prompt me to save the changes and does it automatically. There have been cases where i do not want to save the changes and just wanted to know if there was a simple setting to turn off automatic saves?
View 3 Replies View RelatedIs it possible to put a combo box with a drop down list in the Enter Parameter Values of an update query so that the user selects from the list instead of typing the required value?
Tony
:confused: I have to build a query to do the following
my table consists of 7 fields
cg
price
gross
open
IM
state
sdate
I want to build a query that will prompt the user for 3 of those fields:
price , gross , IM
BUT:confused: when prompted I want the user to have the capability of changing the operators ie: > , < , = etc.
one time they may want
price > 100000.00 , Gross = 50000.00 , IM < 8
the next time they run it they may want:
price < 50000.00 Gross > 45000.00 IM = 4.5
Is this possible
Normally I would run a query like using 'CurrentDb.Execute' so that no user prompt occurs, but how do I avoid prompts when I need to run an update query?.
I'm using DoCmd.OpenQuery "qry_UpdatePW" with no joy!
Have a master table with say
Product no Product description qty
Then I have another archive table with
Product no 1_qty Q2_qty Q3_qty O4_qty
All I want to do is to (at the end of each quarter) archive (transfer) the qty from the master
table to the archive table at a user level.
Meaning I need a control button which does the lot and I suppose prompts and asks which
quarter do I want to archive to. I know how to manually do all that, but is it possible to have
a prompt which determines what field is used i.e Enter 1 then the field Q1_qty is udated.
Hope I have explained this ok.
Appreciate some help.
Thanks Norm
I am using windows XP SP2, Office 2003.
I have created a database to store information from a mine site. I have set up a switch board and most users will just view reports or graphs that have already been designed.
I want the general users to open the file read only without having to open access and use the open read only command. I also don't want to go down the path of database security if it can be helped.
I read in the help page that there is a read only prompt that can be flashed up when the file is opened. Unfortunatly the help page suggests, Tools > Options > Security Tab (tick read only prompt). In office 2003 this option no longer exists (if it ever did)
Any ideas, would be good if i could add something to the shortcut and then have some uses use this shortcut.
Thankyou
I really need some help guys.
For some reason Access always asks for a login/password even if the database isn't protected. Even when I start a brand new database the prompt comes up. Any ideas as to how to get rid of this.:confused:
Hi All,
I am hoping to create form that will prompt the user to enter default values for certain fields ie Week No and WB Date before allowing any data to be input into the form.
Any help on how to do this would be appreciated.
Thanks,
Mary
I was editing one of my tables in datasheet view and when I closed the table, Access asked me if I wanted to save changes. But I didn't make any changes to the design of the table or the filters I had set up. I just edited the data within datasheet view. The reason this is bothering me is that I am afraid I accidentally changed something. The only explanation I have for why it asked me if I wanted to save changes, is that I used the "undo" command to cancel a typo that I made while editing in datasheet view. When I hit "undo", it fixed the typo, and scaled back up to the first record of the datasheet. At first I thought using the "undo" command might have been the culprit, but when I re-opened the table and used the "undo" command again, it undid the change, but it didn't scale back up to the first record of the datasheet, like it did the first time I used the command. Anyway, I am staying away from the undo command from now on. It's about worthless in Access anyway, because it only undoes your last action. Have any other Access users been asked to save changes when they know they haven't made any changes to the design of the table?
View 2 Replies View RelatedOnce at the beginning of each month I extract all new cases from last month into a table. The table has a generic name as I repeat this step monthly. I would like to save or archive the data each month without having to manually copy and paste the table and rename it, prior to the new extraction, so that I have a record of each month. The archived table will not be used in any queries or reports.
The table I want to copy and rename is named 'tblSampleFrame'
At the beginning of the month before I delete the contents of the 'tblSampleFrame' to pull the new data, I would like to copy the old table and include a date in the new name. How would I set up a button on a form to copy the file and prompt me for the new file name? The new name would be 'tblSampleFrame_mmyyyy' where I can specify which month and year.
I have a need to prompt a user for a date, When they enter that date the qry should do as follows.
if rec_date <= (DATE PROMPTED FOR) and rel_date is > (DATE PROMPTED FOR) ,
then
return Qty and a few other fields....
No the DATE PROMPTED FOR is not a field in the table.
Do I need it to be?
I have a query, and one of the fields has a prompt for user input. Is there a way for the prompt to take multiple values?
View 1 Replies View RelatedI have a combo box that is populated by a query. The problem is that the query pulls data from a different database than the rest of the form and it prompts the user for a password to access this database.
Is there any way of coding the password into the form so that the connection to the database is opened automatically without prompting the user?
Thanks.
i have a main form with a subform. the subform value has "ID" value with a relationship with the the main form. now if i delete a record from the main Form, the records in my subform will have no value to relate to.
i do have a Delete Button in my main form , so what i want is, when the Delete Button is pressed, Check if there is any records in my Subform, and not to allow me to delete unless i move these records from the Subform
here is my current Code for the Delete button ....
Hi guys!
When closing a form, I want my system to prompt: "Close without saving?". If yes, I want to continue the closing-proces, but when "no" is pressed, I want to just close the MsgBox-window and of course keep all the data-entries...
If MsgBox("Close without saving?", vbYesNo, "Close?") = vbNo Then XXXXXXX
What do I write instead of the X'es???
// JR