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

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

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

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

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

I need to create a sql ODBC data sourse in access, so that when you load up the access aplication file it automatiaclly creates an ODBC conection. This is the code that I got from the internet. Function CreateSQLDataSource(SourceToCreate As String, ServerName As String, DatabaseName As...

I need to create a sql ODBC data sourse in access, so that when you load up the access aplication file it automatiaclly creates an ODBC conection. This is the code that I got from the internet. Function CreateSQLDataSource(SourceToCreate As String, ServerName As String, DatabaseName As...

I have a Query that calls a fuction I a modules to separate a field, (ie Name = Tome Jones) = Firstname:Tom, Second=Jones) I then run a count on this to see how many Jones, smiths, Shaw that I have in that table, SIMPLE ENOUTH, HOWEVER I don’t want some data to be displayed or counted, ie <>...

I have a Query that calls a fuction I a modules to separate a field, (ie Name = Tome Jones) = Firstname:Tom, Second=Jones) I then run a count on this to see how many Jones, smiths, Shaw that I have in that table, SIMPLE ENOUTH, HOWEVER I don’t want some data to be displayed or counted, ie <>...

I am trying to run some queries to assign/update an empty field called “useridTYPE” with some values based on the contents of another field called Userid. However the Userid fieled consits of a mixture of user information. (inputs from other fields like, forname,surname,initial) The userid...

I am trying to run some queries to assign/update an empty field called “useridTYPE” with some values based on the contents of another field called Userid. However the Userid fieled consits of a mixture of user information. (inputs from other fields like, forname,surname,initial) The userid...

I am trying to run some queries to assign/update an empty field called “useridTYPE” with some values based on the contents of another field called Userid. However the Userid fieled consits of a mixture of user information. (inputs from other fields like, forname,surname,initial) The userid...

I am trying to run some queries to assign/update an empty field called “useridTYPE” with some values based on the contents of another field called Userid. However the Userid fieled consits of a mixture of user information. (inputs from other fields like, forname,surname,initial) The userid...