Recent content by splreece

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