Search results

I think ive gotten myself a little lost! I click on a field(PartClick) on a form(frmWOViewer) which open's a form frmBomViewer puts the value from PartClick into SearchBox and then requeries. Private Sub PartClick_Click() DoCmd.OpenForm "frmBomViewer", , , , , , [frmWOViewer].[PartClick] = "...

Hello i have a form which filters results based on user name, The user selects their name from a drop down and after update a re query is done. The drop down just has its own table with users listed and one left blank This works as it should with this in my query...

Hello I'm using a fussion5 win10 tablet. I'd like to scan a barcode then look that number up in the data base. So i just have an input box in a form that I'd like filled with the scanned barcode. Is this even possible?

I have 2 tables INVENTORY_MSTR1 Stock Data both have a part no: BF102864 If I run a query linking part number/s it doesnt show up in the list I'm trying to run an update query where it queries the part number and then replaces a field (ABC_CODE) with the one from Stock Data. what am I...

Just like thew title says when I click on a box I'd like to copy the content to another box [SearchBox] name = PartNo Control = [PART] I'm sure a simple function? I just cant seem to find it :(

hello again.. I have a form linked to a query. when the form opens its asks for a part number it takes the part number and populates the form with a bill of material (a list of parts). What I'd like is when a part number is clicked on from the list that part number is then passed back to...

Hi there, I have a number of tablets with access 2016 runtime installed. they all pull the same front-end from a network location. However, I get a pop up regarding trusted locations. I found some registry edits that will allow this, but I dont have those locations...

i have two fields from a linked database that I'd like to join. I've put this in the control source but i only get the first [PATH] and not the [FILE] in the output this is what I'm using: =[PATH] & [FILE] I get the same result if I try to do this in a query: FULLPATH: [Path] & [FILE] i...

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

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

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

Hi all, I have a query and when its run I have a pop up asking for the date required. however, I cant get it to filter on that date. it asks for it, but fails to filter on it. This is what i have for the criteria <DateAdd("m",1,DateValue([enter mm/yyyy])) the date format of the field is...

Hi there I hope you can point me in the right direction, We have a few hundered tables that have the same fields in, this was done by my predecessor. Now, I want to run a query on a few of these tables as and when needed. Could I not make just one query that has a pop up asking for the table...

Everything I find says it can be up to 255 chars https://support.office.com/en-gb/article/Data-types-for-Access-desktop-databases-df2b83ba-cef6-436d-b679-3418f622e482 But I have a Short text field which only allows 6 chars to be inputted? what am I missing?

Howdy, I can change the text box background colour using conditional formatting. However, I'd like the forms colour to change to red when a text field has a certain value (ie) 'fail' Is that possible google hasnt return much hope! Thanks in adavnce YouMust

I'm sure it's really simple, but I just cant seem to figure it out. I have a load of test results that I want to filter in a qry so I only see passed results and not any failures. I just cant seem to get it to work at all. Here's my qry best image hosting free The 'Result' field is long text...

Hello, my apologies it's me again. I'm trying to change a field from long text to date/time (StartDate) to suit the actual data. the data in the field is like this: 31/12/1999 - 24:59:99 and my format is: dd/mm/yyyy - hh:nn:ss It works fine in a new field(test), but when applying it to a...

Strangely I cant sort my columns! what do?

Howdy guys, I've been asked to make our access application available to production staff. With the intention of adding build notes and logging build times etc. I'm trying to think of the best way to present this information to the operators. Ideally a tablet but from what I've read so far...

Howdy I'm not sure if this is even possible so thought I'd ask before trying and buying a barcode reader. we need a barcode scanner to enter serial numbers in access but a piece of software doesn't play nice and takes every scan as keyboard inputs even when its minimized. Is there a way to...