Search results for query: *

Hi SkipVought, The foxpro database is a compiled program which has an "export to .xls" function. I don't know what is happening in the background, but it creates an .xls file which I open then copy from then paste into the Access form. The Time field I'm looking at is in "General Number" format...

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've already taken into account the dates in the query and report. to add a bit of detail regarding my table, this is what the records look more like for one machine. A controller creates a data record with individual identifiers (I've used A, B, and C as the data representing those...

Another question - possibly should be another thread: Within the dataset I describe above: [time]=5:00; [Machine]=1; [Product]=ABC; [quantity]=5 [time]=5:01; [Machine]=2; [Product]=ABC; [quantity]=5 [time]=5:02; [Machine]=3; [Product]=ABC; [quantity]=5 [time]=5:04; [Machine]=2; [Product]=ABC...

Thank you Duane. It worked perfectly.

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 dhookom - I didn't understand how to use parameters. Instead I recreated this line chart without using a query (I used the table as the record source) and the chart created without problems. it is only when I use a query a the record source where I have a problem.

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 PHV - thanks for your quick response. It seems obvious to use a combo box now! I still need to select from the drop down menu for each field. It is easy now that there is only once choice to select (the drop down source is the query I used before. For each customer # there is only one option...

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

PHV - I see what you mean. I'll have to take a closer look.

Is there a way I can drive this from Excel? Otherwise while I'm working in Excel, I still have to export the data, then go into access to import it.

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

I just opened an application that starts up java first. My voice messages immediately stopped being marked 'read' before I selected them (I was having the same problem as the title of this thread). When I installed that application a few weeks ago was when my voice mail started being marked as...

I have gone through centerfielder's suggestion and my settings were already set to "No Auto Preview". With my situation, it worked fine and then a couple weeks ago, it started marking all incoming voice messages as read. All my email messages are still marked unread when they come in.

I should have noted, that new ingredients are rarely needed to be added. Maybe one ingredient per year. That is another reason why I wasn't as worried about normalizing the tables more. It wasn't a problem for me until I realized I had to change the queries, forms and reports to include a new...

HI Again, PHV - thanks for the article, and I know where you and Golom are coming from in terms of me normalizing my tables now. JoeAtWork best describes what I had originally. I have the tbl_Recipes, tbl_Ingredients, and tbl_IngredientsInRecipe much the same way. The reason why I haven't...