Search results

@june because i like my own way of doing things. And to see and .compare backup files etc. Admittedly this is new territory and I don't know what I'll end up with... but if nothing else I'll learn a bit more. Then I'll only have to remember it LOL. What I have now is SELECT...

Thanks @june, plog? >you realy don't have a lot of data to necessitate a database. It may be when files are added, but small is an easy start?

Hi Doc_Man, yes it does and thank you for such a good description. I do have other computers, so I expand your list to include a computer name and add another table for computer names. Each table has a common field which is used to join? Or something like that.. As I do it it should become...

Interesting. Do I have an overview? Goal is to find/identify backups. But mostly I'm just going where this takes me. Your drives won't affect mine and vice versa. Yes/No? I'll show what I've cobbled together so far. With no idea if I'm going in the right direction!

This question may be beyond what's expected on the Forum but never having figured it out, I'm curious about database relationships. Northwind and apples/pears/customers etc sort of loses me but I have a real life example that (should it work) might be a good learning tool. My concept is a...

Many thanks for the replies/.ideas. There are apostrophes as well. cheekybuddha's second sql worked. :) I'd forgotten about parameters, I'll dig out some examples and try that too.

leftCurly = Encodings.UTF8.chr(&U201C)rightCurly = Encodings.UTF8.chr(&U201D) Can I convert/use these in sql in Access anyhow? sql = "INSERT INTO " & y & " (Serial, Lyrics) values (" & Chr$(34) & Ser & Chr$(34) & "," & Chr$(34) & TheLyric & Chr$(34) & ")" CurrentDb.Execute sql...

The answer to this is probably No. I'm using a combo box to display some names. It's unbound. I'm also putting the first item into the text box area. (and not using dropdown if the count is just 1). It all works as hoped but two highlights appear - one in the text area and one in the list.. It...

Sorry, by sharing I didn't mean simultaneously. Just both use /access the file. We are using Filezilla to Get & Put it at the moment but if there' a way to automate that it'd be much better. Once transferred to local drive another instance of Access read/.writes to its table.

I'd like to sent and get an access db to an FTP site to two of us can use the same file. I've found a few things with Google (e.g. https://www.codeproject.com/Questions/321083/Automatic-FTP-via-Excel-VBA-Macro) but can't get anything working. That is, even just to connect. Doe anyone have...

I've changed to setting CurrentDB as advised, and set up to read the Drive Volume rather than the serial number. As an experiment I tried .Edit instead of .AddNew and while it did the job, I'm still looking at the tables normalised to see what's what and how it might work.

This would have been a breeze in Excel and become exactly what was wanted, but I'm intrigued by Access and I like the way data is saved automatically without the whole thing needing saved. I've read bits on normalization but it's never made a lot of sense and things like NorthWind examples just...

Doc man, this was what threw me > if you add a field that contains the drive's serial number as a field name, then EVERY RECORD will have that same serial number as a field name because adding a field to a table is a "global" operation. Because I was sure each field was different because its...

I'm not quite sure how to reply Doc_Man as you've blown me away with that ! The period in the fieldname was the error. That aside, my plan was a lookup table for HDD backups. The Drive serial number would be the fieldname and each foldername in that drive would be a new record in that field. Is...

Hmmm I have a further problem, My intent was to use the serial number of various HDD as the field name. But on line MyT.Fields.Append MyF Run—time error '3125': '0025_38D3_21C0_9E90.' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too...

Thank you! Set MyT = CurrentDb.TableDefs("HardDrives") didn't change anything but your suggestion about using a variable for CurrentDb did. :)

Having trouble getting this code to work. It should add fieldname to HardDrives but just shows error 3420 What have I done wrong? Sub AddField(fieldname) Dim MyT As TableDef: Dim MyF As Field Set MyT = CurrentDb("HardDrives") Set MyF = MyT.CreateField(fieldname, DB_TEXT, 255)...

Thanks arnejgp just about to take a look. CJ, sorry that data was meaningless it was just a mockup to show the size and positioning trouble I had. I've been thinking about this a lot. How I put it to Doc_man (rows 2-8, col 3 shows "Fred".) was probably the wrong approach. I've worked out a...

Hello Mike I have attached a file showing the three forms. Don't feel obliged but if you want to offer any thoughts it'd be appreciated. The positioning is about right but the the top datasheet will acquire a horiz. scrollbar if dragged wider, but the bottom one doesn't (which is preferred). But...

I see a lot of articles where there's talk of Customers And Customer IDs and so on. I don't have such things a bit hard to imagine and so used an example that meant something to me. It is used in Access, not Excel. At the moment the table has this data duplicated, so if I can change that to...