Recent content by Tark221

I will check out SQL Service Express, thanks :)

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

If you know the part number, if you start typing into the drop down box it will try to find it if it exists.

This works well thanks guys, the only issue I had was I was hoping the text box's would grow or shrink with content but instead a vertical scroll bar appears.

Apologies for the late reply, how would the second option work. Could you explain it further. Thanks for the help

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

That worked thank you !

So create an update query and set the criteria to a control and update them that way?

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

Thank you, spot on!

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

That works!!! Thank you.

Which part of that code would what you suggest replace. Thanks for the reply pulling my hair out with this one

Sorry to jump on the back of this but at my work we had a similar issue where user profile settings would only permit an employee to open an access db if they first opened access and opened it through file - open etc. If they didn't use this method it would only let one person in at a time...

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