Search results

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...

Oh i knew it'd be something simple.... thanks im learning more every day

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...

thank you i always seem to get stuck on the simple things!! thanks again

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...

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?

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??

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...

been researching this myself, check out http://support.microsoft.com/default.aspx?scid=kb;en-us;304387 hope it helps, thanks

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?

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??

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

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

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...

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...

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...

thanks but how do i do that?

can you do an autolookup from the same table. Example a drop down list box on a form, u choose a value and then another list box below shows all related values.. All this taken from one table??

Thanks so much for that how do i get the query to get the value from a value on a form?

I need help….. Say you’ve got a database that tracks jobs an employee is doing. How would you group all of a particular employees jobs together? If you’ve got a table of jobs, and the employees name is listed on a few different jobs how do u filter to just that employees jobs?