Search results

a screen share would be great, though Im off to my nieces birthday dinner very shortly. maybe we could pick this up tomorrow? I'm genuinely thankful for your help!

I'm sry DBguy, if i could upload it i would. maybe the linked table/s is the issue? I'll try to figure a way of uploading it but yes, that demo is doing the same thing isn't it!

the tables are not in an access db. its PSQL. the tables are linked in access and used by my form. it only shows #deleted if there is no data to display from BOM_NOTES. it cant actually delete it as there is no data to delete, it's null. not sure how i could upload this

thanks @theDBguy There is no formatting applied to that field. the query is here: https://ibb.co/7Vz4ByT

no, the table is populated the qry shows #deleted when there is no data from that table (couldn't find parent/seq) note the arrows on the query design view basically i still want the query to return whatever data it has even if there is no data in BOM_NOTES table.

not sure why the tags didnt work, I've just put the url's in now so atleast they are clickable now. thanks for letting me know!

i have a query https://ibb.co/7Vz4ByT https://ibb.co/sm4L11s When the 'text' field is empty I still get that line in the query as desired, but it places #deleted into that field. So when my form pulls that query it displays the #deleted, I'd like that to be left blank, is that possible...

Well, thats the very frustrating thing about this whole situ. He was brought in when our last account retired, he had lots of new and exciting ideas! One of which was replacing our system, I pushed back on this quite hard having spent a good few months learning access. I was overruled, the...

The PSQL database is from Globalshop solutions its an erp solution. So they have control of the tables/layout. Our accountant chose this software -_- and is why we are moving away from MS access. I've started a ticket with these guys asking about this. Maybe they can confirm what I need to...

I want to search and replace all part numbers within a pervasive database. The part numbers are littered across what looks like hundreds of tables and views(query's). It looks like I can import all of these with no problem, but would I be able to get access to search through all the linked...

You can link your excel document to the the database and set excel to refresh. open excel > data > get external data > from other sources > from data connection wizard > ODBC connection > select your db and your required table. you can then go to properties and select how ofter you'd like...

Hi The_Doc_Man thank you for chiming in! Well, its a bit of both. I was a novice learning access for work, but after a few months the company decided to move to a new ERP system. Using PSQL. I pretty much dropped any further Access research as it wouldn't be needed. So I'd say I'm a rusty...

oh perfect thanks :)

Agreed very wrong to have a table for every part, pretty much everything in this DB is in single tables! Ah thanks guys this seems to be working out well Only issue im having is tables that have a - in the name (ie) 1600XLV-24V I get the error can not find '1600XLV' Its not a big deal though...

Hello, I hope someone can help me out here, I've inherited a database from long ago which has a lot of bills of materials as separate tables and the table name is the part number for that bill of material. I need to join all of these tables so they can be exported to PSQL. The tables all...

Thanks again arnelgp! That was my mistake I used an old form, creating a new form from the qry resolved the issue

There is just one problem, when I marry this with a form. i get an additional pop-up asking 'tblTestResults.StartDate' If I just click ok it loads the page/data fine, any way to remove that pop-up? It doesn't happen if I run the qry manually, just with a form

Ok I got it, Like "*" & [enter mm/yyyy] & "*" Thank you arnelgp as always, a great help!

I've exported to a clean database. So you can see it in action https://drive.google.com/file/d/1twd9tPXNur6BCbADjoSOKq85ShUHglfK/view?usp=sharing

Thanks for your help arnelgp applying this gives no results, unfortunately.