Search results for query: *

On the subreport the formula for the key is as follows: WhilePrintingRecords; Shared StringVar NM_Cust_Contract := {SVC0601V.CONTNBR} This populates the subreport with the appropriate contents On the main report the formula for the key is as follows: WhilePrintingRecords; Shared StringVar...

Thanks for your reply. The key on the main report is a calculated field and not part of the table structure.

The subreport is placed in the report header, so think I am ok there. In this case, the tables cannot be linked (I inherited a very poorly designed table structure). Thanks gain for the feedback...

I built a report in Access that used a variety of dlookup commands to extract specific data, and it worked very effectively. I am creating an updated version of this report in Crystal 10 using a SQL Server database. Unfortunately, Crystal does not appear to have a dlookup function, and am...

I am relatively new to Access programming, but I have noticed that the size of my database is growing very rapidly. I just finished a modest database and the total file size was 30MB (before any data was put in the tables). I did have quite a few reports and other bells and whistles, but it...

Thanks! It worked. I am finally moving forward again.

I think that my database may be corrupt. Here are the symptoms: 1) The file size of my database has fluctuated enormously over the past 2 days (from 2.5MB - which is normal - to 8.0MB to 28MB and now back down to 6.7MB. There has not been any meaningful activity during this time 2) I am...

I figured it out. The form I was calling was actually a subform and I forgot to include the parent form in the reference - a rookie mistake - uggggggghhhhhhhhhhhh

I just finished a report that I was writing and everything was going very well. I literally just made the final changes and was ready to put it to bed. When I launched the report to test it 1 last time I received an error that said "You cancelled the previous operation" I have never...

I am writing a report that needs to pull a date field from a form. I am using the following command in the control source line of the report field, but it is giving me an #Name error on the report. Any idea what I am doing wrong? =[Forms]![Pmt_Main]![PR_Date]

I am wrapping up a database project. I want the database view to be maximized every time they open the file. How do I do this?

Works like a charm. Thanks!

I added this code to the row source line. SR1, SR2 and SR3 are the combo boxes used to capture the selection. SELECT SRQ.Rep_Name FROM SRQ WHERE SRQ.Rep_Name<>SR2 And SRQ.Rep_Name<>SR3 The entire list is being populated to the combo list, but it is not getting updated when a selection is...

I have a form where a user has to select 3 unique items (from a list of about 12 items). I am using 3 combo boxes to capture the 3 selections. I can get the drop-down list to populate correctly from a query I built. However, I would like to limit the list to only the items that have not been...

I am not sure what 'mantissa' is... but you were exactly correct in your analysis. Thank you very much - I thought I was losing my mind.

I am trying to isolate the problem. I created a completely new database and am getting the same problem. After I input the number into the field and double click on the field then the number changes. Could it be a configuration issue? Something is just not right here.

OK - I give up. I can't believe what I am about to write. I have a table that contains a numeric field. The field is formatted as follows: Single; Currency; 2 Decimal places. When I type a value directly into the table the number changes. For example, if I type in 852.54 then the number...

I changed the field type in the table to fixed with 2 decimal places and it seems to have fixed the problem, but I am still very confused as to why it does this

Works like a charm - Thanks for your help on this

I have created an append query that adds records to a database based on the data in a form. I have set up the query to round one of the calculated fields to 2 decimal places before it posts to the database. When I am in design mode and preview the file, the field is correctly rounded (and...