Search results

I have fixed the problem, I feel totally retarded because it all makes complete sense now. I had the record source of the form itself set as the same table the recordset was pulling from. Which was causing me no end of greif. It has all been resolved now, thanks for the help!

This seems to make sense however my utter lack of database experience is preventing me from seeing how I am accessing the same record twice. I am sure I am showing my ignorance here but it seems your telling me that the form has the same record open as my recordset code at the same time. At...

Everything in my database seems to be working fine for the moment except the following code. First an explanation of the form this Sub belongs too. Page one of the form has a listbox populated with data from the Helpdesk table. When you click on the an item in the listbox the a record is...

That is what I thought at first as well. I checked and rechecked but I could not find anything that would add data to the table, and I included the code in case I missed something. That subform was never supposed to add or edit the table and I never wrote code to do that. it is only supposed to...

update - the new record is only added the first time you click inside txtUpdateWL while the form is open. after that no new records are added until you close and reopen the form.

Hello, I have a form called IMO that I use to view and edit information from the table "Helpdesk" On this form there is a worklog command button. When this button is pressed the only code executed is: sbfrmWorklog.Visible = True the subform has the following code written in...

Thanks! That did it, exactly what I needed!

I appreciate the quick response! However, I am a bit confused, I had never heard of the Not in List event so I did a little research and it seems to me that this is only available as a combo box property. Also, in order to use it you have to set the limit to list property to "yes" However...

Hello, I am looking for some help with the following problem. I have a listbox on a form that populates via the following code: strSQL = "SELECT [Ticket Number], [User Name], [Phone Number DSN], [Computer Name], [Building Number], [Room Number], [Date Problem Started], [Type of Issue]...

Update Fixed it, Just needed to create a workspace and use the .BeginTrans and .CommitTrans methods.

I have a form that is designed work with data submitted by other users. This form is designed to update or delete data. Almost everything is working properly except I am running into a record locking problem. the code used to open the record set is as follows: Set rst =...

Re: Thanks alot! What I had done was I split the database manually. Which doesnt seem to work well with a mutli user env, must have done something wrong, but I went back and use the database utility and it seems to be working fine, thanks again!

I started my current project with little to know knowledge of MS Access or writing code with within MS Access so bare with me... I have a split database, the tables are stored on a file server, the "front end" form is stored on each user's computer. I had my database doing exactly what I...

Thanks alot!

Is it possible to concatenate a return space when adding data to a field in Access? For example I want to use a text box to add data to a memo field in a table. Each time data is added I want to add space between the new data and the next update so the field would look something like this...

Re: The way my database works is a user has a computer problem and submits a ticket via the "Helpdesk" Form. All the data they submit is stored in the "IAHelpdesk" Table. Now once this done my techs view the record on a seperate form called IMO. This is where my techs view the record and make...

Hello all, Please forgive my inexperience with access as im sure there are much better and easier ways to do what I am attemting... That being said my issue is as follows: I have two main forms in my database, Helpdesk and IMO. Helpdesk is available to all users in my organization via...