Search results

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

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

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

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

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

morning all, could i cast your eyes over the below as I am sure its a quick fix but I can't find the issue in the structure. CalcTargetDate: IIf( [cmb_GR_servlevel] ="Standard", [dte_datePNGReceived] +10,IIf( [cmb_GR_servlevel] ="Premium", [dte_datePNGReceived] +5,IIf(...

Morning all, I need the ability for users to click a button in the dbase userform and that will select the current record only and save/export the current record to an excel sheet. (this I will then RunCmD to open a word doc merge). This effectively will mailmerge ONLY the CURRENT...

hi all, sorry its a really simple one but am at a loss. I have 1 table and 2 columns (with a code and then corresponding description). "tbl_ccode" "QC_cmb_ccode" and "QC_cmb_ccodedesc" On a new form these are linked on a combo box where u can see both columns but when the...

Morning all, I am venturing into sql but stumped at the first hurdle. I have 2 tables with the same headers and I want to combine the two (i.e. may has 100 entries and tbl_ams_apr16 has 100 entries so I want a unionall to bring back 200 entries. each select works on its own but...

morning all, I'm new to vba so very much loving forums and google. Its a huge learning curve but forums like this have been invaluable... I have a simply piece of code that takes the current userentry and emails it in a pdf... only problem is the page orientation is portrait and I...

Morning all, I have finance package I have put together that includes calculated cells/onclick command buttons showing/hiding tabs and lots of commands running queries. However nothing top programmatically complex. The issue If I open the dbase and userform for the first time and...

Hi all, I am a basic user of access and have limited vba knowledge but am quite a quick study. I have built an access application that has 3+ subforms. I show/hide these subforms via the below code: Private Sub Check246_Click() If Check246.Value = True Then frmAltPaymentAddress.Visible =...

Hi all, I am a relative newbee when it comes to vba although I am very useful in that I have a good level of understanding of excel and access functionality. I have a mailmerge query that pulls by date (-14days from a chosen field date). What I need to do is to fill the date the query ran...