Search results

Sorry I was referring to the previous post where DCrake was trying to go the route of integrating the code used in Excel inside my Access DB. I'd like to keep my Excel spreadsheet as is but be able to send commands to it from a form in Access. Hope that's clearer.

Hi, I thought this would be a very simple matter but I keep searching to no avail. I did find one post that where the person was looking for the exact same thing as me but there were no answers :(. Basically I have a table recording questions that we get. When we log them a time is written in...

Bump up, I'd still like to find a way to send commands to Excel from within Access without having to integrate the code in Access.

Well I don't feel super comfortable giving out the code used since I'm not the author, this is not the whole code but the main part that gathers info. I have obviously removed the URL as it is confidential. Sub RPCpull(struser As String, strpass As String, strdtstart As String, strdtend As...

Hi again everyone, Here is what I have and where I am stuck. I have an Access DB and an Excel spreadsheet. The Excel spreadsheet is built to gather information from a website that contains statistics we use in the office. There is a "front" worksheet that has basic controls such as dates...

Sorry about the delay, I was busy on something else but that worked perfectly! Thank you again!

Hi again guys, I have another small issue with this form. I used vbaInet's code to open the form chosen in the drop down list as follows: Dim stDocName As String Dim stLinkCriteria As String If cboPMMForms.ListIndex > -1 Then DoCmd.OpenForm cboPMMForms.Value End If Now the...

gotcha! Thank you again!!!

It works!!!! thank you both very much!!! I use prefixes btw... I thought that WAS the convention... :s i name my forms frmWhatever and subfrmWhatever...

Ok!!! now I get it! And it does work! The problem now is that this lists all of my forms, I only want the user to chose from a few forms, not all of them. How would I filter the list? And once that's done I guess I just create a command button with the first code provided by vbaInet?

Sorry again for my newbiness but if I get this right I just paste this code in the Row Source Type of my combo box and that should populate the box with the forms? Now I also guess that I have to SELECT every form that I want included? so Would I modify MsysObjects or ".name" to my form name...

That's not exactly what I'm looking for but it will also be usefull for another project of mine so thank you for sharing!

The most probable thing that I thought of was : Dim stDocName As String Dim stLinkCriteria As String stDocName = "[Forms!subfrmPMM!cboPMMForms]" DoCmd.OpenForm stDocName, , , stLinkCriteria but that did not work...

Hello again, Sorry about what is probably a very basic question, I search the web and the forums but could not find the proper keywords to get the answer I want. What I need seems very simple to me. I have several forms which are variations of the original. I need for the user to chose...

ok, is the "YourBaseQueryNameHere" query a simple query of the whole table?

Well that's a great tutorial but it's not at all what I'm looking for. First, I can't use indexes. Like I mentionned in my post, I cannot modify the table in any way (it's a linked excel spreadsheet). I'll try to re-explain what I need. The user selects an agent and the stat he wants...

Hopefully this won't be as complex as I imagine it! I tried searching but am not sure what keywords to use properly so if this was addressed before, I appologise. Here's my problem: I have a table with multiple fields in it. Amongst the fields I have Agent_Name, Call_Date, talk_time...

Hi again, I am realy feeling like a Dlookup retard now. The previous worked perfectly but now I have a new problem. On a form (Settlement), I have 3 bound boxes. The first (Initial_Offered_Amount) records an offer from a client, the second (Settled_amount) record the amount that we...

That did the trick, I had to remove the "Dim txtManager As String" part and it worked like a charm. Here is my final code if ever this helps someone. Private Sub CSS_AfterUpdate() txtManager = Nz(DLookup("[Current Manager]", "Staff_list", "[Full Name] = '" & CSS & "'"), "") End Sub...