Search results

you're completely right about the files table. Had it written down on my notepad but forgot to include it as it was not causing me issues. One thing I am also concious of is size. I'm aware that access has a 2Gb limit per db file. The way I have stored the date is because of size...

I need a record method of tracking progress of a case file and who is responsible for progressing that file. Each file has a unique number associated with it. I will be looking at week on week progress where the weeks are fixed -week1-52. Each person is associated with a file and resolving the...

I work for a reasonably sized organisation (4000+ employees) where we have a data centre that stores our data tables which is populated by our in house case logging application. I do not have control over these tables. Sure I could create my own, but it is quite easy to exceed a million rows in...

Adding a subform for a single textbox/button/dropdown seems more complicated than adding a textboxt. My background is in console applications so to me it seems simple to create a variable called unitID and then be able to assign it the value to multiple fields/variables. If I had full control...

I suppose that makes sense having all the info in one table. Hypothetically though, would it be possible to link the two unitID's without a subform?

ok thanks. I've somehow got it to work without using a subform. I think I changed the recordset type to dynaset. I will do another form using a subform and see how I get on. Since this exercises for me is about learning and has no 'real world' value I'm going to experiment with a few things...

Hi all, hope everyone has had a good Christmas. I'm just trying a few basic things to get a feel for access/database programming. I'm trying to use a form to input data into the tables in my database. At the moment all tables are blank so the form displays no controls. I tried adding...