Search results for query: *

HI I’m running a complex query in Excel>ms query, however as it is complex, (is using 2 ODBC's) it wont allow me to use parameters. Therefore is there a way around it as i need to enter in 2 date parameters. I have looked for table .fields > today() or table...

Hi skip, thanks to your responce, its only a small DB of 32 colums max and 14 rows, Im able to copy and paste data in excel from 1 sheet to anouther and transopose it, but it has no Cell referenceing, and thats they key thing that i need, Any ideas??

I have 2 work sheets in excel. Sheet 1 with data imported from an Access table and Sheet 2 with data transposed/rotaed from sheet 1, (so that the colume headings now read as vertical headings and vice versa) however i want it so that when i change data in the access table or sheet 1, sheet 2...

I am having trouble updating some records on a sub form, I have 2 fields for a record which is being used on a sub form, they are start time and end time, im trying to update the next record's start time to read the prevoius records end time, eg starttime endtime 9:30 10:30...

Hello, I have never used bookmarks and have no idea how they work, I have 2 fields for a record which is being used on a sub form, they are start time and end time, im trying to update the next record's start time to read the prevoius records end time, eg starttime endtime 9:30...

In Win NT mode, when using OUTLOOK, it says that my "deafault mail client is not properly installed", However if i log on as an administrator it works fine, I think it has some thing to do with permissions, but not sure where, Does any one have any ideas

In Win NT mode, when using OUTLOOK, it says that my "deafault mail client is not properly installed", (even oulook express) However if i log on as an administrator it works fine, I think it has some thing to do with permissions, but not sure where, Does any one have any ideas

In Win NT mode, when using OUTLOOK, it says that my "deafault mail client is not properly installed", However if i log on as an administrator it works fine, I think it has some thing to do with permissions, but not sure where, Does any one have any ideas

pwise, you are a star, no you are a super star, it works really well Thank you so much

that is really good and works like a treat and many thanks, but if i want to carry this forwar to say, iff all the numbers in table1 filde 2 are below 10 show form1, else show form 2, rather than getting the number from a promt any suggestions??

That looks good, but it cant run of a form, I have tried to crete a macro. what i tried doing was to make a table based on what number the user enters (using make table query), then say only open form 1 based on the condidtion, therefore macro read,s Run query (this will place the users...

Hi, Im trying to create a query that will allow a user to enter a number, then if the number is greater than 10, show form 1, else show form2, I have tried serveal codes, but it dosnt seem to like showing forms, Does any one have any ideas, Perhaps code can be written in a module? Any...

thanks to every one who posted a suggestions, they were all very helpful

Beetee u r coorect, work has deemed it so we cant use task scheduler, I know that At commands do work, and in have tried looking at the dos help, but still no luck, Could some one please give me an example

Im using Win NT and dont have access to Task Sceduler on Run command. How can i schedule a Access database to open Weekdays at 11.30 pm, on my local machine and not on the server. I been reading past notes and nothing so far as helped,, Any sugestions any one???

I want a form where i type in a date (Ie 25 december 2002) I then want to click a button where anouther box, appears names me how many Months and days From now untill that date, is left I presume it would be something clike NOW - Mydate (and then if possible, be active so it will then tell...

I have a book code, that is duplicated, but i want the user to know how many rows that he is attemted to select, so he can say, right i want to select rows 10-20 today, (then he will work on that) and tomorow he will select 21-30 (and work on that then I dont want to run a distinct either as...

Sorry my last post had many spellings and there fore didnt phrase my quetion correctly I have a very large table, where i want to be able to SLECT records. However as the table is so large i want to be able to SELECT A PARTICULAR AMOUNT OF RECORDS There is NO auto number on the table, and i...

I have a very large table, where i want to be able to update srecords. However as the table is so large i want to be able to it where i choose how many records changed. here is to auto number on the table, and i dont want to change the format. Therefore was question is How do i create a...

Because the program is going to be used for many users on many different machines, so rather than configue each machine individualy it was ment to be easier to do it in access module. Plus that how the Boss wants it done Any ideas???