Search results

rstSupplier.FindFirst "supp_name='" & rstqlivat!qli_supplier & "'" Debug.Print "supp_name='" & rstqlivat!qli_supplier & "'" Produces the below in the immediate: supp_name='2 supp_name='1 supp_name='1 supp_name='1 supp_name='1 supp_name='1 supp_name='1 supp_name='1 supp_name='12...

Was not aware I could do that, much easier - thanks :) The above (supp_name is the descriptive field in tblDrpSuppliers and qli_supplier is the field storing the matching numerical value in tblQuoteLineItems) still has the same effect i.e. only displaying the first record in tblDrpSupplier...

Ok I have made some progress with this now with the help of the previous code and some searching... Dim db As DAO.Database Dim rst As DAO.Recordset Dim rstenq As DAO.Recordset Dim rstquo As DAO.Recordset Dim rstqlivat As DAO.Recordset Dim rstqlinon As DAO.Recordset Dim rstSupplier As...

Thanks both :)

We have a template which is quite specific - but basic - for our accounts team (please see the attached example) and I am trying to export data from access to excel, ideally to fit in this template where possible. Currently I am banging my head against a wall, I can export to excel however not a...

My vba knowledge is limited so perhaps use the below as a suggestion and see if it helps, perhaps someone else can confirm/improve on this! Select the boxes you would like locked to begin with and right click --> Properties, under Data is the Locked option. Then I think an 'On Change' event of...

Adapting the examples for creating a 2 digit year, month, day + "-" and number I have ended up with the below, which is now working: Me.txtq_id = Format(Me.txtq_date_created, "YY") & Format(Me.txtq_date_created, "MM") & Format(Nz(DLookup("CountOfQuotes", "qryQuoteCount", "Quotes= " &...

I have gone through the rest of the database and where appropriate used your approach, removing all the write conflict messages in the process, so thanks very much!

Not throwing away, purely unaware. As mentioned earlier vba is completely new to me and entirely self taught. At the time of initially putting the forms together this seemed like a sensible approach based on the information I had gathered at the time (and the write conflict messages were not...

Thanks, although I cannot fathom how I can adapt the code to work with the existing form... On your form I am right in thinking that it updates when you move to a new record? My problem is that these are removed in my form deliberately. The frmPeople form is attached as an example (Yes the...

OK thanks, how would I go about this? (Sorry, as said before my knowledge of this is very limited!). But once I have one set up correctly I can then sort the rest out myself.

I cannot allow the end users to have access to the table directly - they may edit a record unknowingly or delete information which is required, which is why the txt boxes are used (the actual table fields are on the form but hidden). If they make a mistake they can press the cancel button and...

I have a form for updating contact details of customers/suppliers. Upon clicking an edit button the user can update txt boxes (as opposed to updating the table data directly and making a mistake). When they press save the below code runs: If Not IsNull(Me.txtp_fname.Value) Then Dim...

Thanks, Gina I think I could use the example for 2 digit year followed by an increasing number, so that would get around the 'first record' issue :). CJ_London, I had tried and failed. Not having the vast experience (in fact, very little experience!) that others on this forum have I thought I...

I need to create a fixed length ID field in our access system (will be exported into the accounts system so needs to be a 5 digit number). Table does not have any records to date. Other than entering the first line manually, is there a piece of code which will check to see if table is empty, if...

Never had to use/create one so am looking for guidance! Currently we send out communications to new customers upon placing their first order with us (a thanks for using us type thing!) This is a manual process at present and can be complex tracking back through our invoicing system, hoping to...

Thanks for the tip! The database is set so that a general record always exists for each customer (created on account set up automatically) so it should always be there! The e_id field is 6 characters long, does this need amending to long? Below seems to be working for now at least! If...

Please if someone could let me know if the below is correct that would be appreciated! Staff are monitored to make sure they are keeping up to date with our customers. A customer can have multiple projects going through the factory at any one time. Each customer has a record per project and a...

I tried or, but not and! Thanks, simple and works :) It should not get more complicated than that but thanks for pointing me in the right direction if it does!

Hopefully a simple problem, struggling to find a suitable solution! I have a textbox on a form which requires a date input in most scenarios and the code below has been working nicely so far (it's part of a number of ifs upon a button being clicked hence elseif ElseIf...