Search results for query: *

I have a table called Invoice. It has fields such as Invoicenum duedate Amount and status. The status could be open or close meaning whether the invoice has been paid or not. What i basically want to achieve is to find which invoice is delinquent by (1-30days,31-60,61-90,91-120 and >120). What...

Hi All- I have a small task to achieve. I want to create a form in Access which (Access) would have possibly an ODBC connection to my SQL server database that has a view as my source for data for the form. What i want to be able to do is have the data from the SQL view to display in a form in...

Hi there I have the following code on command button on the main form that displays customers names on the subform on finding a match from the text box. txtCustname.SetFocus strCustName = txtCustname.Text If strCustName <> "" Me.Subform.Visible = True Me.Subform.Form.Filter =...

i have a form frmDataForm that has its record source property set to a view linked to SQL server(ODBC). The form has about 6 fields(textboxes). I have a command button on this form that opens up another form frmComments capturing some of Dataform values. What i want is to make this button...

Hi can plz someone tell me why the following code doesn't give me the expected results. if i do the exact search for strSearchVin = strVinNum...it gives me the correct results but somehow doesn't work with RIGHT function. I wana look up my results from the text box (by exact number or last 5...

Hi All- I have a form with in access which is pulling data from Ms Sql thru ODBC connection (a View). What i want is to have a text box as a search field where the user types in a number or part of a number and it will only display the relevant results in the form. I have done this before with...

Hi All, I have a small access application developed in Access 2007. Every time I run it on a machine that has no access but just the run time files(downloaded from Microsoft site) it pops up with a security notice and if i hit ok the application opens up and works fine..I just wana be able to...

Hi All, I have a main form leaseinfo and then a subform called leaseinfosubform and i have 2 combos on the main form as comp_num and lease_num(depedent on comp_num combox). The subform has several fields including comp_num and lease_num and its placed on the main form and shows data based upon...

My parameter list doesn't display all the values that exist in the table. Any suggestion what could be the problem. But when i type in a value that is not displayed by the parameter the report gets generated which is fine but i want all the value to appear in my parameter list so user can choose...

Hi there i'm trying to pass date parameters from main report to a sub report. The date parameters in the main report gets a value at prompt and then they are compared with the submission date field in the view and the results are returned accordingly. what i have is a from date and to date. For...

I'm trying to create a report which has a format like this: vendor name salesguy1 finace program1 sum(amount) finace program2 sum(amount) Total sum(amount) --for salesrep1 salesguy2 finace program1 sum(amount) finace program2 sum(amount) Total...

I have a report that has some grouping. I want to keep the group together yet at the same time when one group heading has lots of details and it can't fit with other headings on one page i get blank spaces on the pages. What it does that it keeps the group toghether. But if i have that option...

I have a form with four combo boxes and then i have a command button which has an on click event to open another form. How can i force the user to select from all four combos and if they leave any combo blank i wana give them an error or some sort of a pop up message saying "all combos" need to...

Hi, im using the following code in VB to export my reports from a crystal viewer to PDF. I was just wondering how can i add options for setting the printer to legal size paper. So when the user opens the pdfs and they click on print it automatically prints it to legal size. My reports are...

Title: Disable crystal pop up for parameters asked by zafridi on 12/12/2006 02:29PM PST This question is worth 250 Points hi is it possible to disable or by pass a pop up for entering parameters during run time from VB if certain parameter is not provided. I have everything working...

Hi experts, i have a report that is driven by 2 parameters MainId and SubId. The reports are being generated from a view which has fields for both columns. In the report i'm only displaying SubIds with their related info. What i want is i want to have SubId as an optional paramter. So when only...

Hi there how can i display some kind of text for instance 'testing' on a page header during run time in crystal report when a check box is checked off in Ms Access used as front end. And when left unchecked the text doesnt display on the report. any kind of assistance would be appreciated. Thanks

Hi guys i have the following code in VB access which is working fine for me. It creates a PDF perfectly but i need to use some naming convention for the PDFs. i want to be able to capture the current date and time in VB and use that as part of the name. Im using Now function for that purpose but...

Is it possible to suppress/show a text DRAFT on a report from the front end. In other words my crystal reports are used from Ms access (front end) where the user would be given an option of a check box draft. If they check off that box i want to display the word DRAFT on the report and if they...

Hi how can i have group footers with different texts in it. for example i have 2 groups with different headers but for each group footer where im summing i wana be able to insert different text such as sales total and paydowns total. The problem is that it shows it in both group footers. thanks