Search results

The below code does not seem to produce any errors but is not updating any values in each recordset - is there something blatantly obvious which I have forgotten to do (I know its all not justified, have removed most of the code as is not relevant to the post)? FYI me.cmb_date (column 0) is an...

Been working on a database for the local 5 a side team and come across a bit of a stumbling block which I cannot find the answer to! the query qry_team_red shows that for m_ref 1001 there are 2 confirmed players, and for m_ref 1002 there are 3 confirmed players This query relates to...

With the help of suggestions from users on here we have been running local copies of an access CRM system for the past year or so. Now that I have a bit of time to look at this again I am trying to identify a way of setting up a single database with multi user access on the local network. A...

Early in developing access based CRM I found that having multiple instances of the same form ended with issues (i.e. customer notes were being placed against the wrong records etc.) so upon opening each form currently the program checks to see if already open, if so stops the new form opening...

Not 100% sure if this is the correct area to post my question, if not please can this be moved accordingly? With the help of people on here I have put together an access system for daily tasks for the staff at work. This particular issue involves users entering data into a memo field (enter key...

Hopefully a very simple fix... Dim db As DAO.Database Dim strDBPath As String Dim strPictureName As String Dim obExcel As Object Set db = CurrentDb() Set obExcel = CreateObject("Excel.Application") strDBPath = CurrentProject.Path & "\" strPictureName = "logo.png" If Me.chkFullQuote.Value...

With thanks to previous help on here for creating the code below I am able to export quotes out of our access CRM. Private Sub btnQuote_Click() 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...

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

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

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

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

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

Hi all, not sure if this is best suited here (I anticipate it needs some coding!) or in the forms section, sorry if wrong! I have a combobox with 13 options. As the customers order is processed I would like a user to be able to update the status based on its current status. E.g. current status...

Trying to create a record in a table (tblToday) for any dates in the past five days which do not already exist. This needs to include the previous 5 days for other forms/reports to function correctly. The code below is the simplest way I could work out how to insert multiple rows (on a row by...

I have a form that each day needs to be filled in by staff of their activities. By selecting a date, I want to the textbox to display the contents of the comments memo pad field in the table (tblToday...columns are t_date and t_comments). My very limited access and previous SQL knowledge has...

Final few snagging points on a CRM system I am building for everyone in the office to use, with the help from you guys so far I am almost there, so thanks! Background: Sales will make calls and record data using a form (frmEnquirySpeak) which will save to tblSpeak. If the call results in a...

Apologies if this has been posted before, I have not managed to find it so far! Creating an access database for use as a CRM system and need to start building reports into it. I have a table named tblSpeak (2 key fields here are s_date and s_action) and need to create 2 reports initially: 1 -...

Trying to build a CRM system for the office but am getting stuck with the below, any help is much appreciated! Each company (tblCompany) in the database has at least 1 enquiry (tblEnquiries) linked to it and normally at least 1 (sometimes 0) people (tblPeople). I have a form which loads...

I am new to access and have found extensive help on this forum from previous posts so thank you all for unknowingly assisting! I cannot find the answer to this on the forum so far, please point me in the right direction if I have missed something... I have a form (frmMasterPeople) which...