Search results

I am importing a text file into a table in Access 07. SOME of the data has " in front and back and some of the data does not. How can I get rid of the " marks? Example; "BOSCH, HARRY" XTRA CARS I have imported the entire field into a temp table. Now I want to append to a Master table to look...

That all makes sense........I'll do that.

I will read up on normalisation. To answer your question....I really don't know what I am doing but I keep trying. I am sure I will learn a lot. Thanks for the link....

Each month I have to add a new column in a table for the current month. (jan11, feb11, etc...) Is there a way to do this using a form where I can type in the monthyear in a textbox and then click a button to create the new column in the table tblMasterData?

Can you tell me what I need to change to this “very old and reliable code” to select the filename rather than ALL .xls files. This imports ALL .xls files in the folder. I would like to narrow it down one more level and select a specific .xls file to import. Private Sub cmdBrowse_Click() Dim...

Thanks. I guess I'll have to live with that. If (in the future) you run across a solution, I'd like to know. What if I did it in a form rather than a report? Would the code be similiar?

Here is the db. Thanks for your help. I am sure it is something very simple. I understand the code.

rating is the field name. There is no other field named that on the report. I changed it to txtrating anyway. I am still getting the compile error. Expected:Identifier. The report and table are simple. Artist, Song, Album, rating.

Thanks Bob, but I get a compile error on Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim ctl As Control Dim int As Integer int = Me!rating Compile error here - expected identifier (rating is formatted as number For Each ctl In Me.Section("Detail").Controls...

I have a simple music db. I would like to place a rating (stars) in a report based on the field value [rating] in the db. If the rating of the song is 5 then I would like to show 5 stars on the report next to the record data. I have an image called stars.jpg. What type of code do I need to show...

I spend hours just reading (and learning) things about access on this site. Everyone seems so knowledgable and helpful. I have found many answers to my questions. I really enjoy looking throught the threads and getting new ideas about how to upgrade my db's or learning new techniques. Very Cool...