Recent content by withoutaclue

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