Search results

Ok guys, I finally got it to work today in my office...the objects on my form were successfully populated. Likely this will be my last posting to this forum as there are others that are better suited to the way that my office uses Access (unbound forms). For those of you who responded and made...

As for highlighting in the code window...I just noticed that there might be something fluky with the SQL statement (though it looked ok and then I tested it in the SQL window it seemed fine. I will revisit this though I don't think this would return the "Type mismatch"). As for any other code...

Ok, so continuing the VBA newbie learning curve...I have come to a new impasse. Once again, this is with unbound forms, so in an effort to not waste any of your time those of you who feel the need to debate the sanity of going unbound I kindly request that you help someone who is working with...

Well, the explanation of why everything has to be done unbound is because I am running this with a server side and a client side with close to 500 employees accessing (no pun intended) the database. We've noticed that when you get more than 5 people or so in it (if not run server side/client...

Actually I think I should have stated it simpler instead of going into the bloody details of what I eventually wanted to get it to do. Actually, my main question is, after I build the recordset from the table, how do I get it into my unbound form? <snickering at my own over exuberance> I know...

Hello once again, Ok, so I have a question (big surprise)...How do I populate an unbound form with a recordset from a table? I tried searching previous threads, but the majority of the posts were regarding either continuous forms, or populating lists, so any help here is greatly appreciated...

I finally found the answer to one of the problems, it had to be done through VBA. I learned that my form had to be unbound and then I needed to be able to create the recordset from the objects in the form, and then use .Update to get the information to go into the table that I opened. My form...

Trying a different approach...got ALOT closer...no syntax issues this time...now tis just pointing the recordset to the correct objects...

Here is the SQL: INSERT INTO tblTracking ( AppID, AppLName, AppFName, tblMain.criteria1, third party, ActionDate, Notes, empID, empName ) SELECT TblMain.AppID, TblMain.AppLName, TblMain.AppFName, TblMain. criteria1, TblMain.thirdparty, TblMain.ActionDate, TblMain.Notes, TblMain.empID...

I have a form that runs an append query in addition to saving the record (the appended information gets archived in a separate table called tblTracking where I collect the changes that have been made over time to that record). In my main table I have in the neighbourhood of 2,800 some odd...

Ok, so I have now corrected the SQL statement to read: 'Get record information info from the database mrst.Open "SELECT tblMain.AppID, " _ & "tblMain.AppLName, tblMain.AppFName, tblMain.Criteria, " _ & "tblMain.ThirdParty, tblMain.ActionDate, tblMain.Notes, " _ & "tblMain.empID, tblMain.empName...

Opps...how did I miss that???!!!! Ok, going back over the whole thing again.

I run the debugger and I don't get anything highlighted in yellow.

Ok...so, after some more continuing work on my db, I have debugged the VBA code and...well, I am at my wits end why I am receiving "Data type mismatch" errors. So, here is my first attempt at doing a class module. I am aware that I could use a query to intercede for me, but I want to make this...

Question with toggle buttons...since the behaviour of a toggle button is the same as a check (tick) box, True/False, Yes/NO, -1/0...that part I get with little difficulty. I have a form based off of qryUpdate. Now I am trying to use this form for a couple of things: 1)Display the record based...

Thanks for the input :) The reasoning behind using the sweeper is that we will quickly have thousands of records building up in the "deleted record table" due to the nature of what we are using this for, and based upon the disposition of certain records, there is simply no reason to hold onto...

Ok, so I will admit, I am a newbie to Access and VBA, but I have reached a series of epiphanies, and am rolling up my sleeves to get down to business. However, taking into account the lack of computer savvy in my office, I am trying to make things as "automatic" as possible to remove ID10T user...