Recent content by Davebert

I always install 2 CD/DVD burners in my new PC builds. One eventually usually quits burning but still reads . But I do have and external one handy when I need it. In fact in the old days I bought a bunch of 5 1/4 external drive boxes but the were for the old interface (IDE or PATA) as opposed to...

Too bad I didn't cancel it before it shipped as I now have downloaded and installed ACCESS on 3 PC's with downloadable software, and the stuff in the mail still has not arrived! :oops:

Yeah, I think I am still learning so I am likely not 100% sure of what I am doing. I am taking all the help into my brain and then letting it settle. Then doing the research on key words that may be the answer to my confusion. If you read from the beginning I started with a flat file file...

I thought that might be the case. I had to hunt down the default location and it was in Documents. Thanks

No problem. I joined here after ordering an older 2010 version of Office Professional and it still hasn't arrived yet. Then I got a link from here where I bought a very good deal on 2019 Access and I downloaded it last night and installed it. Talk about a fresh noob in Access. Me. :cool:

When I made my first database in my new fresh install of Access it named it Database1. When I made the other 3 DB tables I was able to change their names after I closed them. But Database1 is still the same name.

Ok, thanks. I am finding a few things the hard way like it seems if you name the original files wrong you might get one chance to change the names. I will do some tutorial searching. Added: I just did a simple query and it was too easy. So if I want to do more advanced queries I assume there is...

New territory. Could you let me know where I access the interface for this query stuff? Thanks! :oops:

Don't forget I am getting into uncharted territory now. Where do I access the command line for SQL statements? Thanks

I couldn't open the files from ACCESS as they are type .ODB from LibreOffice and they use some proprietary database called HSQL. I managed with cut/paste from the Calc spreadsheet though.

Ok, I may be stuck now as I have created the whole filament table like it was originally was. Then I created the 3 lookup tables ColorValues, TypeValues, and BrandValues. I made these by creating a new database for each of those. All of the above were cut and copied from the LibreOffice...

@GPGeorge Well I started with LibreOffice Base and I have been getting guidance here on the forum already. I bought Access 2019 and just installed it last night so my simple single table flat file database will get rebuilt with Access and from some of the comments, my database is fine the way...

Thanks for the welcome and the info on how to learn normalization. I know it's going to take some time but I will figure it out if I put my nose to the grindstone. I have been getting some great help already here on the forum but it takes time for it all to make sense but this is a great forum...

Good info. Thanks. I have another question before I get started today to anybody that cares to answer it. When I was using LibreOffice Base I was able to copy my table into the LibreOffice Calc (spreadsheet) and then create new tables by grabbing a column of data and importing it back as a table...

Thanks for this extra add info similar to June7's recommendations. This helps me a lot as I was having trouble figuring out how to split up the data columns into separate tables. Can the reserved word "TYPE" be used if I add an underscore and some other characters? In other words is it only a...