Search results for query: *

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

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

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

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

I have a dcount function that I am running in a query. The dcount has 3 criteria. I can't seem to get the syntax correct. Could someone take a look at this and set me straight. DCount("[Trans_Key]","[Payment]","[Trans_SR]= " & [Rep_Name_1] And [Trans_Type] = 'Com' And [Trans_Key] =...

I have a data entry form that uses a combo box as one of the input fields. When the user selects the item from the drop down list everything works fine. When the user types the first letter of the item (to avoid using the drop down list) the name correctly displays as if they had selected it...

I have a single form that serves as a pop-up data entry form. When I use the scroll-wheel on my mouse it will move to the next blank record. I can reverse the scroll-wheel and get back to my original data entry point. Is there a way to disable ability to move between records on a single-form?

OK - I know this is a silly question, but I cannot figure it out. I am trying to build in some error trapping on a data entry form. This form requires the user to enter various information, including several numbers (integers). The default value is 0 for the number fields. However, if the...

I am working with a continuous form that includes a dashboard of various items, including several option buttons that indicate the status of various projects. I am trying to figure out a way to format the option buttons similar to a red-light / green-light system - where if the value is yes...

I have a query that performs several calculations on various fields. I need the query to be able to round to 2 decimal place AND truncate all numbers after 2 decimal places. I am using the Round function and it is correctly rounding the number to where I want. When this number is displayed in...

I have a continuous form that displays a variety of fields. I only want a checkbox to be enabled if certain criteria in the data fields are met. I need the checkbox to be either enabled or disabled as soon as the form loads (ie: there is no event that triggers this other than loading the...

I am working with a continuous form and am adding a sort feature to the column headings. There are 5 columns in my form and I want the user to be able to click on the header and sort the data by that field. I can do this when the column contains a field that pulls directly from the query, but...

Ok - I am sure this is a simple question, but I cannot figure it out. I have an expression that multiplies 2 fields together in a query. How can I get it to round the result to 2 decimal places. I can change the format to Currency with 2 DP, but it still saves the calculation with multiple...

I have a form that displays a variety of fields. If one of the fields meets a certain criteria then I want a checkbox to become enabled - otherwise the checkbox stays disabled. I am having problems getting the form to do this when the form opens (ie: there is not event - other than just...

I have a form that pulls variables from a table, performes a fairly complex calculation and then inputs the results for each line item on a continuous form. The calculation is too complex to create directly in the Control Source property. I have written code that performs the calculation...