Search results

Well the 7 combo boxes are basically just for a certain visual affect I am trying to achieve. You see a while back I posted in these same forums about how display my data in a certain (unusual) format, and the only suggestion that seemed to work is have the 7 combos with 7 related subforms (or 8...

I dont know if I completely understood your answer, so let me rewrite it in what I interpreted it as... Well first of all my combos are not "bound" to any control source but the do get values from my employees table. But anyway, so I would create a table with 7 fields (one for each combo on my...

I have an unbound form which displays several combo boxes. The combo boxes display a list of employees. Each combo box has an associated subform where on the onLoad of the form and also after update of the combo box, the associated subform's record source changes to reflect the selected...

Although probably not the proper way to structure it, all the strings will be hard coded. Hard coded because there would never be a situation where I would need to add, modify or remove a search string. I was thinking an array. Something like this would in theory work, but I was just wondering...

I need to us an IF Then statement to see if a memo field contains any or all combinations of certain strings. Now I can write a REALLY LONG If statement to include all my search strings like... If (InStr(Me.Memo, "string 1") = 1) or (InStr(Me.Memo, "string 2") = 1) or (InStr(Me.Memo, "string...

There is a good article HERE:http://support.microsoft.com/kb/317113 about how to automate Access from within a VB.net application. I read through it and tried some of it out myself, and it workd just fine, but I am wondering if there is any way to open an access form WITHOUT opening Access...

OK SelectCase OpenMode now has no errors, but I still have the other 2 errors : "OpenDiag() is not a member of windowsApplication1.Customer_Details" and Dim frm AsNew Customer_Details... Under frm it says "Argument not specified for parameter 'OpenMode' of 'Public Sub New(OpenMode as String)'"...

Thanks for the quick response. I inserted the code and had some problems off the bat. Well to back up just a bit, I dont "fully" understand the code you suggested either. We'll get back to that in a minute though. The problems I am having is: (BTW I used "Form1" and "Form2" as easy explinations...

First off forgive me because I am totally new to VB.net. I know a little VBA for Access and if I mess up my terminology, bear with me. What I am trying to do is open form2 from form 1, but in the load event of form2, I want to figure out what button on form1 was pressed to open form2, then...

I have mastered just beyond the basics of VBA and now am trying to learn a little VB. Just for learning purposes I am trying to recreate one of my completed Access database in Visual Basic. I downloaded Visual Studio 2008 Express Edition. I realize that in VB you cannot have bound forms as you...

Ok thanks for all your help.

I didn't use the "Name" as the name of the field, I was just typing quickly in my last post. Thanks for everything, and I dont want to be a pain now but I have more information that I left out in my last post that may or may not change your suggestions. I also have a charge table that holds...

Well I was going to ask that question about normalization, but then I would be veering off the main topic of this question. But since it is kinda solved now I guess I can. The standard amount is already saved in another table, and I figured I would save the custom amount in the customers...

Thanks... I tried your code and it "kinda" worked. I bound my field/control to my CustomAmt field, but for any record that did NOT have a custom amount it copied the standard amount field to the custom amount field, technically working, but having nnecessary data. Then I got to thinking and I...

Are there any workarounds to not being able to edit a field based on an expression? Let me explain my situation… I have a form based on a query created from 2 tables. The control source of one of my fields is: =IIf([BillCodeID]=1,[CustomAmt],[Amount]). I understand that you cannot update...

Thanks, and although this sounds like it would be just the simplist thing to do, it is not really possible, at least no easy way of making it possible without restructuring all my code, and then having to restructure all my other forms that use the same code. You see the form I am having a...

Upon close of my form I am gettign this error "This record has been changed by another user since you started editing it..." Now I know why I am getting it, but cant figure out a way around not receiving this message. Let me explain... I am using the QuickBooks SDK to connect my Access db to...

I am using Access 2007, and YES, I am referring to the Access window, at least for the main part of my question. You may have mis-read a part of my question because I dont recall asking how to open the "Main" window in a larger window, but I was asking how to open a Report window in a larger...

I am using the SetWindowPos API function on startup of my database to, well basically resize and position my database window on my screen. Everything is working pretty well with it, but I have 2 exceptions... First, I guess it's kinda built into the function, but after running the function...

Thanks. I looked it up a little (never used it or heard of it before) and at least what I grasped from this article is that the GetObjects function is used for MS Office applications only. Now I am probalby WAY off on that assumption though, but i need the window caption of my QuickBooks...