Recent content by David44Coder

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

Say I have a table with 16 records and 23 fields, and some of these are to be populated with data from a second table, how does the PK (or FK) or query put that data where it's wanted? e.g. so rows 2-8, col 3 shows "Fred".

Thanks Mike, just give me a little time to organise an upload. I'll be very interested in what your say as I've just found (although it works) at times the Forms are empty, when they shouldn't be, but I haven't yet found when or how. And if course, it always ok when you want it to show a failure.

It's very good of you all to be so helpful, thank you. Doc Man, Kris Wenzel's article was the most informative, and CJ's explorations. My table could be best described as an 'active' spreadsheet with some Access routines doing stuff better than say, Excel. There's no relationships or Primary...