Search results

ahh thank you very much so remove the first and last [] and replace with () to wrap both into a single query.

Morning all, Kind of a newbee question but I am getting into more complicated stuff and may have bypassed some fundamental query techniques. I think the cause is that I want the user to fill in as many unbound boxes as they need (and leave unneeded ones blank), but the query is assuming...

ahh ignore that.. I have it working however its saying duplicate output decision when I am trying to import the AppNo field as well (works fine when I don't import appno)

Thanks for the quick response.. I've created a new simple dbase to test it. tblMasterTable = the original (main table) ltbl_CSVImport = the linked import file qry_Append = the append query The Initial Query works great. But on append I get the error message access cant append these...

Thanks for the quick reply. Its CSV files athat re used for daily datadumps.

Morning all, I am new to import via vba/access so its probably a basic question. I have a current dbase, that could be updated daily if needed. The dbase is small (only 7 fields), but the entries are in the 1000s. I am looking for a way to update the current dbase by: - If entries...

Morning all, Is it possible to create a button to export the current entry only? My IT teams wont allow read/write access to any drive therefore the only way the dbase will work is for a local copy of the dbase be saved and each user completes each entry to be then exported and emailed to...

doh.... thanks for your help everyone... it was simply the field and text box name were the same (I normally do that so I know what refers to what).. maybe going forward I get into the habit of the dbase field ref and the userform box ref have different conventions.

Hi minty mem_RequestDetails is a memo (text box) essentially the user keys in some details for a task and on pressing submit, I need a way to close the field (so no amendments) and then the rest of the vba is complete and functioning fine (separate sub). if I use me. it states...

Hi there, Thanks "The error is runtime error '438': Object doesn't support the property or method." Then on debug is highlights " Me!mem_RequestDetails.Locked = True" I've ensured the mem_RequestDetails is selected via the ctrl&spacebar method incase of spelling. I have also...

Hi all I have the following code Private Sub Command93_Click() If Not Me.NewRecord Then 'Lock YourControl for each record. Me!mem_RequestDetails.Locked = True Else Me!mem_RequestDetails.Locked = False End If End Sub it should work as far as I can see as the "RequestDetails"...

Morning all, strange question with possibly an obvious answer of no, but thought id ask anyway. There is a need to build a dbase suite that all users in the org can use... however. Most users only have read access to the network drive therefore save locally only. How do I go about...

thanks Ranman Is there a way to do this programmatically. My users are not very smart when it comes to naming/IT etc. So ideally, I would have a button that they click to select their file, and as part of the vba process, their file would copy to a predefined directory and then take...

hi all, just a quick one. Is it possible to use the attachments element on a userform, but rather than it save itself in the database, it simply links to a directory (or copies the resource into specified directory). I potentially have 2000+ new entries per year so if all have...

Afternoon all. I am a relative newbee so I may be asking something that can't be done easily, however, I have been successfully using the below search script for a while which has been fantastic (thank you access.programmers.co.uk). However the challenge is now, to create a search script...

Ahhh that makes perfect sense... and is a lot simpler than I thought it would be. for some reason I thought I may have to do some sort of find/match formula (excel style fiddly thing).

thanks for the advice Ranman, and yep I have it as cbo, it was my typing skills failing me on the query. I wasn't sure about the logic behind the search and show side of the process. So once I have the completed list, how would I actually structure the onchange action to either...

Morning all, I have been able to find onchange examples and if else then working formulae but am struggling with finding an onchange example where the on change queries the text string against a table and if matches then produces a msgbox. I have field "txt_tag1" which is a combobox of...

Morning all I have cunningly locked myself out of a userform by doing the following: - Turning off menus and quick clicks in the settings options - Turning off shortcut menus and naviation in the form settings - Loading the form as a modal - Hiding the navigation pane So...

Morning all, A strange one and one I can't find anything on the interweb.... I have a dbase with 8000+ entries... that is constantly added to. Each entry is emailed in a report to an owner. Ideally what I would like is for each new entry added... is it possible to have a...