Search results for query: *

Hi Aceman - thanks for reply, In response to your queries: Yes to first point and Yes to second point I have space on main form - but I wnat sub-forms that are connected to Main form to use this Calendar as well - ie one Calendar on main form that feeds 16 date filds spread across one amin...

Hi everyone, I want to have a form where the user can open a calendar and pick a date and that date would shown then on a text box so the user can type the date or pull a calender and pick the date from there. I have two dates that need to be like that. I just find out about Active X Control...

Hi everyone, Does anyone know if there is a limit of how many cases can you use. I have to calculate 20 thing but I have about 150 differents kinds of items so I was thinking on using a case statment but then I will have 150 cases. and I just wonder if there is a limit. This is what i need to...

Okay, Does it matter if the data comes from a query? I created a table and a report and it works great when the report pulls the data from the table.

I am having the same ptoblem I am trying to concatinate City, State and ZIP. and I am getting #error. =Trim([City] & ", " & [State]& " " & [Zip]) I get the #error on all the records?

Hi everyone, I'm having a thing happening when I'm trying to edit multi text I can bearly see the text. On my Pc I need to change to style so I can see it. IS trhere a setting that I'm missing? Other guys can iopen the same drawing and see the text without changing anything. Any ideas?

Hi everyone, I have a table with a field named "Date added" When I try to write the following code: CNT2 = DCount("*", "ORDERS", "Salesman='" & [Forms]![SALE_REPORT_F]![INIT_IN] & "' And Date added between #" & [Forms]![SALE_REPORT_F]![FROM_IN] & "# AND #" & [Forms]![SALE_REPORT_F]![TO_IN] &...

Okay I got it, I have a field named Date Added but when I enter on criteria I didn't put the dateAdd which it need to be there. sorry. It's working great thanks for the help. Chavito

It give me this error mesg: Syntax error (comma in query expression '(((ORDERS.[Date Added])=("d",-1,Date())))'

I have a query and I want to tell it to get the information from yesterday. How can I tell it to do date() -1 so I can get yesterday data?

Actually The Application is on his Hard drive I just copy the Spreadsheet to the server so I can open it up in other PC's and even the other PCs are opened it from the server their are faster than the one that opened it from it's own HD. This PC is a HP Pavilio 513x, I was wonder is there is...

I saved the file on the server and Open it up woth other Pc and It opens pretty fast, But when I do it from the The PC in question it takes 26 seconds to open and about 15 second to close. I reinstall Office 2K but still doing the same thing.

Hi everyone, I have a PC that takes a long time to open a spreadsheet. This Pc is running XP and Office 2k. 1.6Ghz 512Mb, I try to open the same sheet on a different PC and It opened right away(Small Processor 350Mhz). I disable the antivirus but still pretty slow. Does anyone have any...

Exchange acount that our internet provider give us and has our domain name.

I have a Pc where, 3 users use this PC for internet access they all sign in with a different username. 2 of these users have and e-mail account and they use microsoft Outlook. The third users doesn't have and email he just surf the internet. One of the users is been getting e-mails all kind...

Hi everyone, I have a Pc where, 3 users use this PC for internet access they all sign in with a different username. 2 of these users have and e-mail account and they use microsoft Outlook. The third users doesn't have and email he just surf the internet. One of the users is been getting...

Can you help me with the syntax, can I use between? this is my code: CNT1 = DCount("*", "Est", "SalesPerson='" & [Forms]![SALE_REPORT_F]![INIT_IN] & "' And TurnInDt = between #[Forms]![SALE_REPORT_F]![FROM_IN]# #[Forms]![SALE_REPORT_F]![TO_IN]# AND ordernum > 0")

Try >= [From Date] amd <= [To Date].

That works great. But How do I retrive the value and put it on a form?

hi everyone, I have a query as follow: SELECT Est.SalesPerson, Est.TurninDt, Est.Ordernum FROM Est WHERE (((Est.SalesPerson)=[Forms]![SALE_REPORT_F]![INIT_IN]) AND ((Est.TurninDt)>=[Forms]![SALE_REPORT_F]![FROM_IN] And (Est.TurninDt)<=[Forms]![SALE_REPORT_F]![TO_IN]) AND ((Est.Ordernum)>0))...