Search results

thanks Kahwar I will look into that.

I have some data I would like to go into a report e.g OrderNumber: 123456 QtyOrdered: 10000 We process orders in sets of 3000 so for the above data I would require 4 reports. 3 reports will be for 3000 and the remaining 1000 on the 4th report. So far I have tried with no success...

Not sure if 2007 is the same as 2003 but in 2003 if you want to show a drop down box with say the values of months, Jan, Feb, Mar, etc then you need those values in a table that the combo box will look up. You use a combo box from the form tool box. That will bring up a wizard asking what you...

You could do, however given time your new tables will become larger aswell then you are back to the same problem. Perhaps some form of Archiving the main table to limit the amount of data in it at one time?

Would it not be easier to open the form in design mode then go to INSERT/DATE AND TIME. Then pick up the time from the form and place it in the table? Or in the query itself put a time stamp.

doubt you will be able to do it in macros but you can in VB if you write code to open Excel, open the workbook, remove the password protection then run your query then use VB to set the password protection on again in excel before you save the file. This may point you in the right location...

Hi all, I have a query that uses and ODBC connection to get data into an Access table. I also have a button that outputs that to a server location as a text file. What I need is everytime you hit the output to button it names the resulting text file sequentially. However the first part of the...

Hey Dude cant reply in to much detail as I am in work.Basically what you want to happen is the form to open automatically and on opening perfoms some sort action i.e check the reminders table and them email those reminders that are due, so: 1. Create a query that queries the reminders table and...

are you familiar with Zoned and Packed fileds? Maybe start looking there first, I know I have had issues linking PRMS to oracle because of this.

Maybe look into some sort of "always on top" function but just for the form you want to see not the whole database?

Currently a pre-fabricated false ceiling some anaying flicking lights and an air conditioning unit. :p

Hi James, many ways to skin a cat but lets keep it simple, if its just day by day that you need the reminder for, i.e you dont need to check for end dates and times by hour then its nice and easy. Simply everytime you open the database (I assume you close the application and turn your computer...

Not sure but I would get round it by running a query before that to select the person you want the runnnig total for, and then join the result to the running sum query.

hi Ken thanks for the reply. However I need this in a graph format that I will insert into a form so it needs to be done in query. Is it possible to base a graph on a report?

Ahhhh this is doing my nugget in!!! I have a simple table with 4 fields ID (unique number) DATE (date) CAPACITY (number of SKU we can hold) ORDERS (number of SKU on order) the data looks like this ID DATE CAPACITY ORDERS 1...

either that or use the database to track the original word documents? so you would search for a document by title or catagory and it would give you a location i.e \\yourserver\wordfiles\word.doc. Then all you would need to do is place the original word documents on a shared drive and only need...

if saving the document as text and importing is not working then it would suggest that the tables in word are not in a "format" that access accepts. Remember importing tables in access requires that the table are absolutely consistent: every record must have the same number of columns (fields)...

Finally found it a couple of pages into the search function http://www.access-programmers.co.uk/forums/showthread.php?t=135721&highlight=NUMERIC Regards

Hi Guys, How can I change the format of a table using a query? basically after the query runs the resulting table all needs to be in a text format even though the fields I am querying are in numeric?

ahhh thank you :) i did try that but didnt join the tables. Been working too much on As400 query today to see the simplest of answers in access :rolleyes: