in 1 table there are are 3 feilds
folwer_name
no_of_flowers
total_cost
another table (2 fields)
name
price
eg:
name price
rose 15
tulip 20
Now I want o make a form
with 3 fields
folwer_name
no_of_flowers
total_cost
eg: if some one select 'flower_name' 'rose' and quantitly '10' then total_cost = 150
How can I do this ? using query or anything else plz gimme detals
Hi, i have created two tables, containing the same fields. One table if for '1 day tests' and the other is for '2 day tests'. I need to keep these two in seperate tables.
At the moment i have two seperate forms, one for each type of test, but as the fields are all the same, i was wondering if i had a combo box, so the user could choose whether they wanted a one day or two day test and filled in the rest of the fields, the record would then be stored in the appropriate table. Ie 2 day test table, if the chose 2 day test on the combo box
Thanx
Hi all,
I have two date and time fields which format are like: 15/09/05 09:48:43,I have another field which calculates the time difference between these two fields. I am doing a calculation on the time difference field and want the time to be displayed as for example 03:00, but at the moment it just shows 3:00.
This is the control source which has some formatting in it:
=Int(CSng((([txtDateDel]-[txtdateRO])-[closed])*24)) & ":" & Format(([txtDateDel]-[txtdateRO]),"nn")
I have tried adjusting this but am having no luck.
I would be grateful of any help,
Thanks :)
How do I use a wildcard in a query, see attached .mdb
Table "myDATA"
Sam and Zeb have serial number 23a4224A and 23a4224 in their records.
I want to locate a serial number(s) in multiple fields of a table, based on the users input with a wildcard.
query "Serial Number query"
Enter Serial Number: the user enters: 23a4224*
What am I doing wrong?
Thanks
My combo box problem is still at large!
I've tried every way i can, and i cant get the rowsource query right.
If someone could look at this and post a fix, so that when one uses the "training record" form it allows you only to select course dates that are already in the tbl_course_dates table.
Thanks so much
http://www.suicidenotesmusic.net/nonworkingcombos.mdb
:( I changed my input mask in my form to 99/99/0000;0;_, but my form dates still look like 1/1 /2005. I want the 0's to be visible. Please help.
View 1 Replies View RelatedI'm trying to create a little dbase for personal keeping track of a number of companies I deal with, so that i store their details and also the products they distribute.
In more detail, I want to have 'fixed' product categories, which will be assigned to supplier, and each category will include the product models I have set, including their details (such as price, manufacturer, country of origin, etc).
My point is to be able to create several customised reports and listing:
1. All product models I have in a category including their details.
2. Report per supplier to view their details and the products they distribute
3. Certain product models in a list with their local distributor (companies I deal with).
I assume it involves a couple of many2many relationships, however I have created a file in MS Access but never managed to have it work properly.
Any1 have an idea, or template maybe?
Regards ;)
I want to delete a relationship temporarily so that I can delete a record. After the record is deleted I will restore the relationship immediately. But I am concerned that this will ruin any queries I have already established or ruin my other records.
Could you let me know if this is possible without making a mess of things that have already been established.
Thanks
Carrie
I have pasted the code that SJ posted on another thread that any changes to a record will ask the user to save before closing the form, this located in the beforeupdate event.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If MsgBox("Save changes?", vbQuestion + vbYesNo) = vbNo Then Cancel = True
End Sub
The problem i am getting is that if the user selects no it pops up another message saying "You can't save the record at this time" followed by a description.
How do i prevent this second message appearing i cannot find a thread with this in?
Thanks as always
Mike
I have created a form that with an image control called imageview with the following code.
Private Sub Form_Current()
Me.ImageView.Picture = Me.AlbumCover
End Sub
Albumcover is a text field containing the path of the bitmap.
All is fine unless i move to a new record in which i get an invalid use of null error on the code. Can someone help me remove this.
Thanks
Hi all, long timer viewer, first time poster
Any way, im not nearly as experience as all you, I have a small form, on the form I have a combo box, the form shows the relevant info with regards to what is selected in the combo box, the source of the combo box is a table, the data in the table is alaphabetical, but when you select the combo box the data shown to select from is not alphabetical its all over the place!
Hope that explains it, its driving me nuts!
Hello,
I have a very strange problem:
I have a table linked to an SQL Server table in my MS Access 2000 Application containing 5 text-fields (SQL Server Type, in Access seen as MEMO-fields) and several other fields (in total about 140 fields). Updating any field works fine except for some records. In those records I can only edit the non-text-fields in my application. When I try to edit one of the text-fields I get a error message telling me that another user has edited the record and i have to discard my changes.
The strange thing is that this problem only crops up for some records. (1 in a 100 or so) All other records work fine.
Does anyone know what happens here? And how this can be fixed?
Thanks.
Kaine