Search results

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

Good info. Thanks for posting this. I will switch to this from now on as it is not hard to make the change. Are underscores safe to use? It looks like it according to your list.

I noticed when I reply to a post that has a link in it I get an error or warning about possible spam etc and if I removed the link from the quoted text I can get it to post. Is that because I am new and am moderated until I get over a certain number of posts?? And one of my replies is missing...

Thanks for the added info. I just got it installed so I have some catching up to do. I don't think I will miss those features from v2010 because I just bought it yesterday and it's in the mail and on it's way. @GaP42 Thanks for the info on the reserved words and the ID (field) naming...

I actually had this exact video open on one of many tabs in my browser yesterday but didn't have Access yet so I only watched a few minutes of it. Now it will make more sense. And as a matter of fact, I used to do a little VB6 coding so all that form stuff is going to be easy for me adding...

Ok, I think I need to slow down and re-read and play around and absorb all this good info and let it sink in. I appreciate all the help so far and will be working hard to get it done. Also, thanks for the link to the Access deal. I bought the 2021 retail version for $9.99 USD and am downloading...