Search results
-
V
Saving and updating a calculation
Hi I'm creating a small stock control system. I want to be able to update stock levels. Simply by entering new amounts of stock when they arrive and adjusting for stock used that day. I've created a form from a query which takes current_stock level and then I enter a value (say 50) and it is... -
V
ORDER By Date (SQL)
Oh i knew it'd be something simple.... thanks im learning more every day -
V
ORDER By Date (SQL)
I have a query which i've ordered by date with: ORDER BY status_reports.date; But I want it to display in reverse order with most recent date first for example i want it in order of 18/sept/05 then 15/sept/05 then 10/sept/05. im guessing i just need to add to the above SQL but im not sure... -
V
Prompting for specific dates
thank you i always seem to get stuck on the simple things!! thanks again -
V
Prompting for specific dates
Hi all Im wanting to open a sales report, but I want to be prompted to enter dates FROM and TO so that I can get specific sales. Example "Enter start date" here i'd enter 1/8/05 "Enter end date" here i'd enter 31/8/05 that way i'd get all sales throughtout august. Then when september comes... -
V
Saving a Form field into a table
Many thanks, My report is based on the query, but my calculation is on my form not in my query. Where in the query do i enter it? -
V
Saving a Form field into a table
Help!! I have a form created on a query. I created a field to add up the cost of all components on the form and now I need to save it to a field in a table so that I can run a report (my invoice)! Any suggestions?? -
V
Saving a calculation field
Having some problems with a calculated field on a form. The field came from my table but I typed in the calculation (=[cost_price]+[sale_price]) and it works fine but it wont save to my table so when I run a repot off it doesnt have any of the calculated values because they arent saved in my... -
V
Mail Merge is Reversing My Dates
been researching this myself, check out http://support.microsoft.com/default.aspx?scid=kb;en-us;304387 hope it helps, thanks -
V
Mail Merge is Reversing My Dates
im having this same problem. i've tried adding switches to the end of the code but it doesnt solve it! What switches do u recommend? -
V
Date format in access to word mail merge
In doing a mail merge from access to word, all seems fine, except that the date format is incorrect. On the form in access it shows as dd/mm/yyyy correct for UK. However checking thro the mail merge doc it has swapped over to mm/dd/yyyy, american version. Can anyone help me with this?? -
V
Quick Question
Can you have a cascading combobox on a form and from that have it auto lookup and fill in the other fields? For example chose department, then employee, then show all their details??? Thanks -
V
Expression Builder
Im using the expression builder and the expression i have works fine. It works of a specific form but i want it to be universal to any form thats current that has the field on. so i need some sort of [*currently open form*] or something like that. Can anyone help????? Thanks -
V
combobox relationships??
I have a relationship between 2 tables that links fields "universalID" to "model". What happens is when i select the universal ID it shows all the models in stock with that ID. But i want to do this on a form with a combo box. So I choose the UniversalID from my combobox and then a list is... -
V
Exporting A Report into Word
I have a report that shows all the details I need to send to other clients. I can print it out fine. Although I have large blocks of text that I copied and pasted from a word file into it, to save me having to type it all out. But when I try exporting to a Word file It doesnt show the blocks of... -
V
Combobox then autofill
OK i was going strong before I hit a brick wall. I have created a form with cascading combo boxes on, first one chooses the generic item, the second then chooses a specific one, then i want to fill in all other details on the form automatically from the secound combobox (the specific item) For...