Search results for query: *

Hello, This is my first time using Crystal Reports. I have created a report from a SQL database view. there is a datetime field that I am using to query my report. This is a daily report that I need to run. I have just found out that the data in my view is converted to GMT time which is 5...

I have never found a easy way to do date math, but this is what I use. I basically convert all of the time to minutes. the field with the times are [starttime] & [endtime] Use these fields in a query starthours:=Format$([starttime],"hh",0,0) endhours:=Format$([endtime],"hh",0,0)...

Awesome, Thanks!! I found another way to do it. If you are interested? I created a query "SELECT [table1].seqno, [seqno] Mod 4 AS Expr1 FROM table1 WHERE ((([seqno] Mod 4)=1));" Then append to a temp table (just like yours)with an autonumber field. This gives me the output like your...

Thanks for the reply. The print sequence number is determined by postal coding software. There will be various records. up to 60,000. This is just basic addressing data.(Seq, name, address, city, state, zip) the ordering needs to be dynamic depending on the number of records. if I print in...

Try ="variable" in the control source of the text box.

I think I need to explain more. I am printing postcards with address information 4 to a page. I am using columns in the page setup to get the 4 records on a page. The addresses are in a zip code order & I need to keep them in sequence. There is a field with the sequence number. My issue is...

Yes. There are only 2 options #1 #2 #1 #3 #3 #4 #2 #4 Next Page or Next Page #5 #6 #5 #7 #7 #8 #6 #8 This will not work when cutting the report into quarters

I need to print 4 records to a page, then after printing, cut the reports in half then quarters. I then need the 1/4 sheets to be in sequence. I am thinking I need to reorder the records somehow. I think the reports need to look like this: (3 pages) #1 #7 #4 #10 Next Page #2...

Single form or Continuous? Are you adding fields from different records?

It Worked. Thank you

I have made this work before with hyperlinks. This creates more problems for me though. When the hyperlink is selected the main form automatically minimizes (is there a way to control this because it does not happen on all machines?). The form is a pop-up that does not have min/max buttons which...

I have a table with paths to other databases ex. Company Path CompanyX "C:company\xdata.mdb" CompanyY "C:company\ydata.mdb" Companyz "C:company\zdata.mdb" I want to display the company name in a continouous form & add a sub to the field that will open...

Yes it does. Thank You

I found what the problem is but I am not sure how to fix it. the path is \\company\company files\2003\database4.mdb The folder name is "Company files" with a space. Is there a way to make this work? I can not change the name of this folder.

I am creating a report that lists amounts in the detail from records in a table. ex. Year #1 #2 2003 5000 800 2002 4000 800 2001 3000 1200 I am trying to find the difference between the previous record. ex. Year #1 diff #2 diff 2003 5000 -1000 800 -400...

The single quotes do not work either. Does it mean anything that the error: "Microsoft Access can't find the database file '\\company.mdb'" has company.mdb as the name of the file? I thought that was odd. I have tried similar code on other networks & it works fine. Could it be...

Still not working. I used the following path: stAppName = "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE \\company\companyfiles\2003\database4.mdb" This works on my home machine & my machine @work. It just doesn't work when I put the database on the network. I am getting...

Thanks. I will give it a try.

Is this what you mean? Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" \\company\companyfiles\2003\database4.mdb" Is this a valid path?

I am trying to create an Access application that opens multiple Access applications. I can get it to work on my home machine with: Private Sub Command2_Click() Dim stAppName As String stAppName = "MSACCESS.EXE C:\2003\database4.mdb" Call Shell(stAppName, 1) End Sub I can...