Recent content by YouMust

no no, you got it spot on! Thanks CJ once again :)

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] = "...

Hi Cj thanks for you helps yes when the blank 'user' is selected ALL record's should be displayed even if there isnt a user listed in that field (ie) blank) [Forms]![frmWOViewer]![Combo] OR nz([Forms]![frmWOViewer]![Combo],"") ="" Works great thanks CJ

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 just get this to work with trim In criteria I put =Trim([INVENTORY_MSTR1].[PART]) i get results but the above part is still missing -_-

ah, I should of known! Thanks DBguy

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

unfortunate it doesn't, I can't open the runtime as admin. secondly there isnt a check box to tick Thanks for your input though!

You know, I still get the pop up asking if i would like to open this file... though it did fix an issue where clicking with touch screen tried to open it twice resulting in two dialog boxes. I guess i can live with this! I think its as close as I can get.

ah the issue was with the hyperlink, If you recall a previous post I made regarding constructing a file a path and i used TRIM() & to trim the path and then concatenate file name. I needed to trim the file name and not just the path, both had extra space(?) after the chars. So...

ok should of been Private Sub Command32_Click() Call GoHyperlink(Me.[Text30]) End Sub though now i get an error: Error 5: Cannot locate internet server or proxy server.

I'm having troubles adding this to my form, It says it acts just like hyperlink() but. The below doesnt seem to work Private Sub Command32_Click() Dim ctl As CommandButton Set ctl = Me!Command32 With ctl .Visible = True .GoHyperlinkAddress = Me.Text30...

that looks perfect, thanks @theDBguy once again!

Sorry it was my bad, I'd logged in as me and not the user -_- Thank you for your help though. I now dont get warnings when opening access as I added the drive and sub directories to the registry. However, when I open a hyperlink to a .PDF stored on the same drive, i get a new warning message...