Search results

Hi there, I thought I would throw this out there and see if I can soak up some advice. At work I routinely build small project applications in Microsoft Access 2003-2010. Most of these are built with 10-20 users in mind. I use the normal process's of splitting the database with the end user...

Hi All, I need one textbox which for each record in a query it will add the comments section of the record. So say there are 4 records i would want the textbox to show the messages with a new line then the next message etc. message 1 message 2 message 3 etc... It's to create the illusion...

Hi there, I have the following code below which will update any of the fields in a recordset. Dim dbsHelpdesk as DAO.Database Dim rstAbsence as DAO.Recordset Set dbsHelpdesk = currentdb Set rstAbsence = dbsHelpdesk.openrecordset("Absence") rstAbsence.MoveFirst Do until rstAbsence.EOF If...

Hi I'm populating my listbox from access but it doesnt like my SQL statement, where am I going wrong sSQL = "SELECT * from Process where ParentName = '[cboCategory]'" Process is a table and cboCategory is the excel form control. The error is "No given value for one or more required...

Hi all, Apologies if I've posted this in the wrong section of the forum, I wasn't sure if it was more of an Access or Excel question. Just a bit of background on my problem. I have a combobox and a listbox on an Excel Form, on the combobox change event I query an Access Database which...

Does anyone know how I can write VBA code to Write vba code. In the simplest explanation. I need to write code for a button which doesn't exist yet, but when the form opens it will be dynamically created, this all works, I just need to write the code for that button. We do know that the button...

Hi Everyone, I have one table with raw data in with various columns one which is CustomerName. I have a table with 2 columns "CorrectCustomerName" and "VariationCustomerName". This contains all the correct Customer Names and how they should appear with the variation of the name next to it. The...

Hi all, I have a query about writing code for form controls which don't exist yet. I have code which dynamically creates buttons when a form loads based on different criteria, I need to write code for those buttons. I've tried creating sub procedures with the name of the control but when the...

I'm struggling to find a solution to my problem. I have a box with a long note in, I want to click a button and transfer it to another box but in the second box I need each line to be 75 characters only. So every 75 characters there needs to be a new line. Any help is much appreciated Thanks

Good Evening all, I have a problem I'm hoping someone can help me with. I will try and keep this brief. I have a paragraph of text, I have to paste it into a system which allows me 75 characters in a line and 208 in a page. I have code which creates text boxes dynamically based on the total...

Hi all, I'm stuck. I have a textbox with about 400 characters, I also have 5 textboxes next to it. I want to click a button and I want to transfer the characters to the other textboxes 208 characters at a time. Any ideas ? Thanks

Hi everyone, I'm using a Dlookup in expression builder and it's only returning the value of the first record rather than the criteria I specify. Has anyone come across this issue before? Could someone give me an example of a dlookup. Thank you

("Staff Name: " + staffName + " Date: " + dateSend + " Call Time: " + callTime + " Reason: " + reason + " Expected Time Off: " + expectedTime) So that is my code above, this is the body of a email that im sending from vba excel it works just wanting to know how to enter paragraph...

So i have my forms completed and my workbook done, now i want to make it so i just double click on the file and just my form shows not the spreadsheet, any ideas?

Hey everyone I have a for with a list of staff, on each row is the staff name, age, address and a few more details I also have a view staff form, on the for i have a drop down of staff names and a few blank text boxes, I want to be able to pick a staff name from the drop down and when this...

Private Sub delete_Click() staffName = DelF.ComboBox3 Sheets(staffName).Select ActiveWindow.SelectedSheets.delete End Sub This is my code - there is some code which i havent pasted which dependant on what you pick in drop down 1 depends what you get in drop down 2...

Just a brief summary: I have 2 forms: One form is for adding new staff to a spreadsheet, the form creates a new spreadsheet and renames the sheet based on the staff name - this works fully The second form is to add absences to a staff member, the problem I'm having is I need the data to input...

Private Sub ComboBox1_Change() 'If Candice is picked in box one then 'her team will populate box to the right Me.ComboBox3.Value = "" If Me.ComboBox1 = "Candice Smith" Then Me.ComboBox3.RowSource = "=Smith" Me.ComboBox3.Value = "" End If End Sub This works but how would i say add other...

When submitting the data into the newly created spreadsheet for some reason it's entering it into row 14 i thought this code made it so it entered it in the next free row which would make it the second row down from the top Dim iRow As Long 'find first empty row in database iRow =...

A button on a user form which when clicked will create a new work sheet. This possible? Thanks