Hi all,
I have a form that is used to Enter and Edit records. At the end of a record is a "shipped Date". This is blank until the item ships. I want to make the entire record editable up until a date gets placed in this field. Is this possible? and can editing of the record still be done maybe at the table level?
can anyone tell me how to stop additions and edits on a particular record in a form, plus the subform that the main form contains, im trying to put the event behind the change of a text box, shipped date, so when its changed you cant add or edit the record which is the order.
One the face of it it sounds quite simple - i have a table that holds various bits of info about a customer but also a field that contains a holiday period - what i want to be able to do is show all records that do not equal todays date.
So if today was 11/04/06 - and one of my customers had 11/04/06 as one of his holiday days he would not appear on the report but all the others would.
SELECT tblClientDetails.FirstName, tblClientDetails.Surname, tblClientDetails.MobileTelephoneNumber, tblClientDetails.SentTextMarketing FROM (tblCategories INNER JOIN tblItems ON tblCategories.CategoriesID = tblItems.CategoriesID) INNER JOIN ((tblClientDetails INNER JOIN tblOrders
[Code] .....
this does not allow edits on a continuous form. the edit i am trying to do is the check box. it will allow edits if the grouping is not on but if it is not on then i will get many duplicates of client details.
so how do i set it up to allow edits but still only get one instance of each client detail.
heres one that just don't add up from the beginning, i've got a form that puts data into a table from a text box named txtcomments, the table allows 255 chars to be stored the comments are show later using a copy of the input form, all this works great. now i'm taking this data and inserting it into another table using sql inset in the vb editor so i can play with it and leave the original in tact everything works fine on my test machine but when i transfere the database to the server i am only permitted to enter 127 chars in the text box i've narrowed it down to the sql statement and know that where the error is occuring ive tried deleting things and reinstalling im just going round in circles and when i transfere the database back to the test machine everything works fine the test machine uses access 2003 but the server uses 2000 this is the only differance
any help would be god like
john
ps sql statement as follows looks fine to me,
DoCmd.RunSQL "INSERT INTO tblHistory VALUES([txtcomments]);"
I have a problem that seems like it could be very similar to this post from a few years ago http://www.access-programmers.co.uk/forums/showthread.php?t=46645&highlight=vba332.dll My problem is I dont know how to use Access other then open a program. This is for a customer and they dont know how to do it either as someone else devoloped their database. Basically it looks like the database is corrupt but I can not open it using a newer version of access because it has some permissions and I dont know how to go about making my access "look" like the other computer. Any help is appreciated Thanks James
I created a database for my company and it works very well but, I need it or something to track the way I pay comisions. Its a type of multi-level company and pay rates vary. Also, once someone hits the top level they now join in profit sharing. The profit sharing part is the tough part becase say person A is at the top he is a team leader and he gets money not only from his sales, but also from the people in his group below him. It must also be able to pay the correct person if someone quits, say Person D, the system knows that it all off person D's people under him go up to person C now. I hope this isnt to confussing, but im starting to confuss myself as im trying to set this up.
Is access able to keep track of an organization like this or should I try to use something else?
What I want to do, is have an unbound form, user enters data in to it, then clicks on a 'save' button which then writes the data to a new record within a table
I have got no idea what it is called so find it hard to do the search.
Im trying to make a simple database in access , so far all is going well but im stuck with the inventory. I have "products" table with Id [autonum],name[text],price[money], provider[number], stock[number] Providers table with Id[autonum] ,name [Text],tel[number], Employes table with Id[autonum], name[text],tel [number] and i have Sales table with Id[autonum],date[date],employer[number],product[number],quantity[number],total price[money]
I have relationships between table.provider and provider.name then sales.employer with employer.name and sales.product witht products.name.
Now what i want to do is that every time that i make a sale it modify my stock number on the products table. I think the proper way is just to calculate stock every time i need it but i dont know how to do that either :D Ill upload my db but i have to tell you that is in spanish so if you haveany question im here to answer.Thanks a lot to all
I ve performed a query on a table and now have a set of results which is fine for example £1.56, £1.98, £87.90 (ive set the values in to a currency format), now i want to calculate the total so i have run another query on the last and used 'sum' in the 'total' this calculates the value but rounds it to the nearest integer for example 91!
the thing is i have done this many times before and havent had this problem! i cant understand it, its seriously doing my head in. Ive tried allsorts including the 'round' function which doesnt alter it.
I want to allow users of a database to view data through a form but not to edit or delete it. I have set Allows Edits, Deletes and Additions to "No", but this causes the record-finding combo box I have to search for records to stop working. It works again if I enable Allow Edits, but then users can edit the data through the rest of the form. Is there a way I can allow edits to the combo box but not the rest of the form?
I have created a database in which I have three Fields. 1. Date Joined 2. Renewal Date 3. Member/Renewal
When I type in the date a person joins our club, I have made the renewal date come up displaying a year ahead, when renewal of membershiip is due.
I would like to be able to put in the date joined date and have the field 3 show Member and then when the renewal date is reached, to have in automatically change to Renewal.
It is probaly a simply formula but I can not get it right.
I have installed on my PC, WindowsXP sp.1, MSaccess versions 97 and XP. After I have tested some databases, MSaccess 97 don't works successfully more, but XP version works good. I can't modify files mdb. Access works like in run-time mode: bars and commands reduced, standard icon of access absent, database window absent, ecc. If macro autoexec or a form that play at the start of mdb are present, mdb works but it is impossibile to modify it. Otherwise mdb dont works, I can see access window with only menu files and window.
I have removed access and after yet installed it, but it don't work successfully.
maybe other application leaved files (or modification in file registry) that install procedure of access97 cant rewrite? And that dispose access 97 to work in run-time mode (or like)?
I am hopeless. Can You help me? Can you give me a list of files to remove, or list of modification to do in registry?
please can some1 help?? i created a form using wizard to display the information in three tables but wen the form is in form view theres nothing displayed yet in design view all the information is present. please please some1 help:(
I made a little Access app for a friend, to do his invoices. Access wouldn't allow me to copy the db to a CD, but advised me to convert it to a Master. I followed all the instructions (honest!). Afterwards, I could burn his db to a CD and, on his computer, it opened but wouldn't allow edits or new records - not terribly helpful for an invoicing program :eek:
Since then I've tried creating a new admin in his name, re-setting all permissions, blah blah ... Basically, it looks like there is loads of help on securing a database but very little on un-securing it enough to be transferred to another PC!
The dang thing persists in allowing everything except edits & additions :confused:
I can't find out how to convert it back from a Master to ... what, a slave? :p Even so, that wouldn't be the answer coz I'd be back at square1.
I use a PC running XP and Office 2003. My invoice-less friend has a PC with Win[NT]2000 and Office 2000. I converted the database to Access 2000. I am way out my depth here, but hoping you Access swimmers will be able to advise :cool:
i am relatively new to databases so this is a fairly basic question.....
I have a form. Within this form all records are locked as i do not wish users to change details. However i am told there is an option allowing the editing of existing records upon request. is this true?, as it would improve my form greatly
I have a db where a planner inputs a commit date. The problem lately, is that the commit changes day to day before the part if filled. Management is looking for a way to count the number of times a commit field has been updated? Is there a better way to do this? I have minimal VB knowledge. Please help!
I have a check box field in table, i want this field to be work as if once checked cannot be unchecked again... no worries if done through queries, vba etc
We have 3 different sizes 1x3 2x3 4x6..I want to make 3 separate forms that have multiple sections that can be chosen.Upon Request I can Supply each separate Label with arrows to show what fields need to be changed for each Sales order.For the 1x3 Labels we Make:
1. ETL - We change model # - We Change if the Labels Says Dry Damp or Wet Listed.
2. MISC. -One Plain Txt Box that can be edited in the center
For the 2x3 Labels:
1.Box Labels -Customer -Item -Sales Order# -Shipping Location (For the Box Labels I was thinking I have a Table that holds all this data and all I would have to make is a Query then a form)
2.ETL -Change Model -Wet Damp or Dry 3.CSA -Change Model -Change the Wattage (3 Different Places) -Wet Damp or Dry 4.MISC -6 Text Boxes (From top to Bottom not side by side)
4x6 Labels: 1.HID Box Labels -Item -Watts -Color -Medium or Mogul Based
I have a variable cost that is a calculated field (as in the colum only exists in a query not as a colum in a table) that is variable hours * variable rate....the problem is ppl at my company sometimes dont know how the costs are goign to be broken down so they only put a Variable Cost....
and since they dont know the rate and hours my calculated field returns nothing...
how can i accomplish this, VBA might seem the way to go but i don't know how to use it for Access.....
so basically i need to calcualte the variable cost only if they enter something in var hours and var rate...other wise the var cost should just be what the users type ( so i i guess i have to make Var Costs a column in the table to give users the option of entering it)
I have a qry I need for picking the info for sending a series of letters out. I finally got it to work and now Im wondering if there is a better more efficient way. The qry I call to generate my report calls on information from 10 other queries and 7 tables. Some of the other queries are needed for other sub-forms that rely on the data. Is this something I should change? or just be happy it works??? -Dan :D
Hello, Really hope someone can help me. I have 2 lots of info in 1 table - nameley customer address & posting address
I need to print a form that always has the posting address on the same side. but in some cases if the postal address is the same as the customer address then it is not filled in. hope this makes sense: