Search results for query: *

Hi - I am currently exporting a data table out of a foxpro database which I have no access to modify. I export the data files into an excel spreadsheet, then copy and paste the data into a form in Access 2010. In the original data, there is a field "TIME" that is being recorded as text, not...

I am trying to rename a report in an Access 2010 database. I am getting the error "Database is currently unable to rename the form, report or module to..." I have closed all objects and still get the error. I close the database and reopened as it states but with no luck. Only one post came...

When I create a chart on an MS Access 2010 form, i have two data sets which are significantly different. When I move one of the data sets to a secondary axis, the bar chart type goes from side-by-side bar chart to a stacked bar chart. how can I maintain the type as side-by-side bar chart with...

Hi. I have a number of production records from many machines, with many product codes. The table gets populated chronologically with data from all machines. example: [time]=5:00; [Machine]=1; [Product]=ABC; [quantity]=5 [time]=5:01; [Machine]=2; [Product]=ABC; [quantity]=5 [time]=5:02...

Hi - I am trying to create a line chart in an Access 2010 report. I am currently getting the error "The Microsoft Access database engine does not recognize '[the criteria in the query]' as a valid field name or expression. I am able to run a report off of this query so I know it works. In...

Hi - I need to be able to do the following: 1)Enter "customer #" in a form field/control 2)Hit a button to run code to complete form fields with address, city, phone number, etc. which comes from a "customer" table. I would like to do this in vba instead of having a sub form (with a query...

Hi, I am trying to find out how I can update a control based on the value from the previous record, i.e. Inventory(newrecordvalue) = Inventory(currentrecordvalue) - InventoryChange or Inventory(currentrecordvalue) = Inventory(currentrecordvalue-1) - InventoryChange I can't find any...

Currently I have an excel workbook, where I enter information, then I run a macro which generates a report and then generates another excel file with some data output. I do this each week. I use an excel spreadsheet because of the complex nature of the information (it is linked to other...

Hello, I am dynamically adding fields to tables, and I need to add those same fields into existing queries using the same procedure. I have no problem adding the fields to tables, but can't find any postings (here or elsewhere) on how to dynamically add a field to an existing query. This is...

I want to tab through controls, and when on a control (already tabbed there, and it has gotFocus), I want to hit "enter key" and invoke code. When I use the "On Enter" event, when I tab to a control, it runs the code automatically. I believe that is because "On Enter" actually runs before...

Hi, I am trying to run a procedure from within a procedure: ------------------------------------- Private Sub Procedure1() do task.... End Sub ------------------------------------- Private Sub Procedure2_Click() Run Procedure1 (this is the code I need) End Sub...

I need to copy information from a single record in a continuous form (this is really a subform, but I don't think it should matter) into another form. In each line/record of the continuous form, I have a Yes/No box, that when clicked will open another (different) form. Once the new form is...

I starting using a new printer, and when I did this, the formatting changed on all of my charts (made in forms, then cut and paste into reports). I was asked to choose to 'format to new printer', and when I did, some of the charts continued to print in color, while others will only print out in...

-I have two access 2000 front ends. One is a working copy, one is a development copy (exact same with a few minor modifications). -I just upgraded to Access 2002, but the database files are all Access 2000 format. -I have one form with two subforms on it. The main form has some controls on...

How do I query and group data for a period of time greater than one day when the I want the 'days' to be grouped from another time, i.e. 05:00 to 05:00 every day instead of 00:00 to 00:00?