New Db building stuff
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
Stupid question, but how do I see the properties of the combo box? when selecting or right-clicking it shows. the property of ActionName
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: New Db building stuff
Open the form in design view.
Select the combo box.
If you don't see the Properties pane or Property Sheet (the exact name depends on your version of Access), press F4.
Select the combo box.
If you don't see the Properties pane or Property Sheet (the exact name depends on your version of Access), press F4.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
Ok, it says selection type: Combo Box, I was looking at all of the properties, sorry.
Now how do I fill out the ActionId with a specific number/test once the ActionName is selected?
Now how do I fill out the ActionId with a specific number/test once the ActionName is selected?
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
A number/text 46-49. I feel more comfortable having that, for instance the entry this morning is not one of the 46-49, but it is still an entry into the table. I know you feel it doesn't necessarily belong and I can see your POV, but I still fall back to the entry is there even if it doesn't have a action, rather like a bank.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: New Db building stuff
There is no point in storing the same information twice, even if it is in slightly different form...
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
There is no point in arguing either.
Thanks for your help
Thanks for your help
-
- NewLounger
- Posts: 15
- Joined: 16 Aug 2022, 05:39
Re: New Db building stuff
Did you see the example I attached?
To manage a database it is first necessary to read at least what is indispensable in order to understand what one is doing and not improvise at random.
To manage a database it is first necessary to read at least what is indispensable in order to understand what one is doing and not improvise at random.
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
Please attached it again.EileenStifone wrote: ↑30 Dec 2022, 10:34Did you see the example I attached?
To manage a database it is first necessary to read at least what is indispensable in order to understand what one is doing and not improvise at random.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: New Db building stuff
It is still attached to this post on page 1 of this thread.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
As I explained to Hans, I believe that both are needed. Different data, that has similar meaning. Actionname is a text field, ActionID is a number.EileenStifone wrote: ↑29 Dec 2022, 12:25In the attachment you will find the modified file.
The ActionID field looks like it shouldn't be needed if you enter ActionName directly.
In the tables you should worry about managing the property Required to Yes in the fields if the entry of a data is necessary and not as now which allows you to save a record by valuing only one field, any one.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: New Db building stuff
An alternative: include ActionID in the Action table. I have attached the modified database but I will also post screenshots of all the changes I made.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
Hans I toyed with a similar idea but not a automunber/index nuber. I think that might be usefule if the drop down has two columns and bith would be displayed in the dropdown.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: New Db building stuff
I set Column Widths to 0 to hide the first column. If you clear that property, you'll see both fields in the drop down list.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
Ok, I tried setting columns to 2 and hitting delete key on width, and of course I get an error must be a valid number(something like that as I deleted the error message). This is not your table that may have been in the zip file, but my table named TradeNum with field 1 NumType(Number) and field 2 NumDesc(Text) images attached.
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: New Db building stuff
In your screenshot you appear to have cleared Column Widths (not Width) successfully. But if you still have problems, you can set it to (for example)
0.5";2"
0.5";2"
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: New Db building stuff
May I respectfully point out that you have Quntity instead of Quantity in both Trades and frmTrades.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
Thanks for the heads up. That a key is on the left side of the keyboard side of the keyboard, which is affected by previous stroke.
Width needs a number also. I get the same #Name? With TradeNum as row source and control source all the entries appear as #Name? so that won't work and with that I have to go back and resign the whole Db, maybe. Without opening your zip file will that work NOT to have an autonumber but just a number?
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: New Db building stuff
Yes, it can be a number (long integer) field too. The only difference is that you will have to enter the values yourself instead of Access generating it automatically.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1416
- Joined: 08 Jul 2016, 18:53
Re: New Db building stuff
That won't be a problem as it is a one time entry for multiple uses. There are perhaps many more entries than the five I chose(Other-added), and that would make it grow, but in this instance five is precise.
Thanks for your patience and help.
ETA: This is a beginning, even though I more or less assumed a industry similar method of accounting, but alas ASSUMPTIONS make an ass out of you and me. Not true in almost every field, but workable.