Search results

When importing a CSV file, sometimes a few characters that Access must not recognize are in the file. On import, Access simply stops importing the rest of the rows and acts as if it had imported everything. Has anyone come across this and created a solution to it? The character I have found...

What is this saying? Anything like 18*?

I am trying to figure out a way to take a month and convert it to a certain amount of weeks. For example, a month starts on 12/31/03. I want to to add 5 weeks and show each week added in a column. So it would look like 12/31/03; 1/7/03; 1/14/03... Does anyone know how to get this accomplished?

I use the Microsoft Excel 10.0 object references in a database. The problem is that when someone else opens the database and runs the code if they have Excel 2000 I need to go in and add the Microsoft Excel 9.0 object library. How do I solve this issue?

I would like to create a report based of a crosstab query- the report takes in all fields on the query. But the fields will change. So it seems to me that I need to write the SQL to make the report grab all the fields and do what it does. But I do not know where to start. So if someone can...

I get an error on a form that is perplexing ot me. When the form is first opened and a person inputs and then clicks a "save" button I have placed the error # 29068 occurs. The code behind the button is: DoCmd.save acForm, Me.name DoCmd.GoToRecord , , acNewRec It asks to end or debug. If...

Can I make a crosstab query go more than 4 quarters at a time. For example, I have information for quarters 1,2,3,4 of year 2001 and also quarter 1 of year 2002. Can I have the crosstab query pick that up somehow? Thanks

I have a checkbox on a report and want it to diplay true or false rather than the checkbox. I export this report to Excel and the checkbox gets dropped.

What is the deal when a report prints out dates that are not in order, but thee dates are in order in the underlying query?

I have read through the issues that cause a query be unupdatable. My issue is that: The query contains a group by clause. I use this group by clause to show the records that need to be changed. Has anyone had a similar issue and how did you get around it?

I have a field in a query that uses the Dsum() function. I want the field to be formatted in currency. I have set it to be currency on the properties but it does not change it to currency. Why is that and how do I fix it?

Is there a way to create a report, most likely using VB, to add all fields from a query into a report? Then add two groups to that report? (I don't want to use the wizard because the fields will change everynow and then in the underlying query) [This message has been edited by jesseb (edited...

I would like to have a query run using a variable in the select part of the SQL. The variable allows the query to be dynamic. Here is where my code is at so far: DoCmd.RunSQL "SELECT ExcelImportUnitsForecast.{put in variable}, [Price]*{variable name} AS Revenue" & _ "FROM...

I am creating a database to track sales forecasting. I have one table that has Revenue. This table has fields for months. The fields are like this: SKU; Jan-02; Feb-02;... I would like to sum the all fields except SKU continually. So if I were to add another field it would be included...