Search results

In Access 97 (I have 2010) I created a small database to analyze the table that can be created using the Database Documenter. This allowed me to look at what Tables and Queries are being used by the other Queries in the database all at once and on one page. Basically it allowed me to take a step...

Thanks. That worked great!

I've got a table with a five character part number. I would like to add a field that contains that part number with an asterisk at the front and back of the part number. 12345 becomes *12345* This is to create a barcode for scanning using a Free 3 of 9 font. Here's the catch - I'm using...

Wow! That worked perfectly without altering it at all. Thanks for the help.

No I'm not familiar with Open file for Input #1. I should point out that I'm using MS Access 97.

This is a recurring process. I believe the list I gave you is called a component list. There is also a magazine list, a feeder list and a few others that I can't remember right now. The source data is just a text file. They are cleverly named: cmp.cmp mag.mag fdr.fdr They all follow the...

I don't have any control over how the data comes to me. I will be using C00 as the key and looking at C01, C02, and C08 for sure. C00 is a part number and should be unique C01 is the package type of the part C02 is a description of the part C03 I don't know what this is - I'm not using it C05...

Ok. How do I do that?

I have a machine that spits out data like this: C00 28894 C01 0805-05 C02 Res, 10_ohm C03 FALSE C08 8mm C081 TAPE_MAG # C00 28897 C01 0805-05 C02 Res. 1k 1/8w 1% C03 TRUE C08 8mm C081 TAPE_MAG # C00 28898 C01 0806-05 C02 Res, 2.21K_ohm C03 FALSE C08 8mm C081 TAPE_MAG # C00 28899 C01 0805-05...

I'd like to put an internet window into a form that takes me to a specific URL and then lets me browse from there. I know how to open an IE window from MS Access but have no clue how to open one up in a form. Please help Kip

I'm working with a database where everyone is allowed into and they are allowed to use most of the database. Changing and altering the database is allowed by only the administrator. Is there a way to set up the database so that it skips the password screen and goes straight into the database...

Thanks for the info on naming things. I'll use those conventions from now on. What I'm looking for, however, is some automated way of naming these things as I create them - not after word. For example: After a text box is created when you bind it to a field named Price it will...

When making command buttons in forms, such as a button that will open a form named Form B, I would name the button Open Form B - that is if I remember at the time. Similarly, if I'm using a text box that displays a field named Price, I would name the text box Price and the label would be named...

Thanks Pat: But I don’t have preference on how to structure the db. The only preference I have is in how to structure the scorecard form. Someone here at work suggested using an append query so that I can have the form that I want and the proper tables. Not sure if that would work, I haven’t...

Could a table be made for data input only, and then upon clicking an ‘enter’ key the data is loaded into another table? Where the first table is the undesirable 36+ field type and the second is the easier to use 5 field type. The first table could be cleared each time it is loaded into the...

Thanks guys. I think I’m convinced that I do not want to have a table with 18 or more fields. However, this makes my original question even more important. If the data entry form is to look like a score card (which is what I want) I will now have to have 36 records on that one form (18 for...

I am creating a golf database. We play match-play, which means that instead of looking at the final score, each hole results in a win tie or loss and winning the game is based on how many holes were won. So the hole-by-hole scores must be entered into the database. The approach that I’m...

I am trying to create a chart in access. The chart will contain anywhere from 5 to 5,000 points out of around 428,000 depending on the query. I’m having problems with the scale - I’d like the chart to automatically use the minimum value charted as the min Y scale and the maximum value...