Search results

Hi Minty, Sorry I was referring to ridders initial reply for exporting attachment files and linking them to the database.

This is what i was struggling with before, can't seem to find any step by step methods online...?

The raw data itself is too large (I exported it all with a VBA macro).

Hi Ridders, Are you talking about transferring the data to the disk drive and hyperlinking to it? I spent a couple of days looking into getting this working but struggled with it which is why I decided to delete the bulky, less important data.

Hi, thanks for your suggestion. Sadly, most the size (1.8GB of it) is in that one field so splitting down further won't help.

Hi All, Long story short, my database is at 1.9GB so I need to perform drastic action before I hit the 2GB limit. Is there any way to delete only pictures files from the attachments field? I have PDF's which aren't too large (150mb in total accrued over 2 years) which i would like to keep...

Hi Chuck, Gravedigging here as there is not a lot of coverage over running out of space due to the attachments fields...! I'm following your guide religiously and now struggling at the form stage. I've been able to get the form to open and show the filtered query data but have not been able...

Bingo! Thank you.

Hi Guys I have managed to get this working: Private Sub FilterLoc1_Click() With Me.[DS].Form .Filter = "Serial = ""1.5""" .FilterOn = True End With I would like to change the code to look for a like statement of "1.*" but have not managed to get my attempts to work. Any help is appreciated.

Hi, I can not get this working.

Thanks, half way there.. Now setting the value in access i get "the value you entered isn't valid for this field". My Data type is set to number but the source grabs data from another table: SELECT [tblProducts].[ID], [tblProducts].[ProductID] FROM tblProducts ORDER BY [ID];

Hi Guys I have a linked table from access to excel. Some of my fields are drop down lists and the data linked is reading the first column, the ID column (which is hidden in access). Is there a way of asking excel to look at column 2 rather than 1? Thanks

Hi Minty, Thank you for your help, I have no idea with access so have given up on the task.:banghead:

That worked perfect for joining the two tables. I now need to join all the tables together to get a view to display: RigID, BayID, SerialNo, Build, TestType, Failure, TestCompleted, TestComments When add add another link I get an error saying it could not execute due to ambiguous outer joins?

I think I'm half way there but my query shows no data. I have 400 bays in the table and have joined it (i think?) with the test table. Can you spot what I have done wrong?

The filter will be able to show whats on test and even filter out individual rigs but I am stuck with being able to show unoccupied bays. The list should be able to show all 400 bays even if they are unoccupied.

Thanks, just copied over the relationships as pictured. What would be the next steps to take to be able to display and edit the 8 currently on test records for each rig?

Hi Both, I have updated and populated the tables to what you have suggested. I will delete the previous table/query/forms once I know that I no longer need them (I may need them to see how i done things previously). Please can you have a look at the 4 tables and suggest if they are OK and...

Apologies for the vagueness. We have a test lab which test consumer electronics, which I'll call 'equipment under test' (EUT). The lab has 50 test rigs which each have 8 test bays, each bay can test one EUT at a time (total of 400). Location: This string records where the EUT is on test with...

That's a good explanation of things! I've attached whats I have managed so far above.