Recent content by mattborn

Currently I'm running SQL Server in house for our Intranet. I'm now planning on having a publicly accessible website that also uses a seperate SQL server. Could someone explain how I would accomplish the following. I want our employees to be able to update the data on our Intranet, and then have...

Well the reason I am doing this is that I use Crystal Reports to generate a report off of this data. The worksheet I currently use has macros, autofilters, and data validation. I can't get Crystal Reports to work of the original data, I have to copy the data I want to another file to be able to...

What I want to do is make a duplicate copy of the data in one worksheet into another worksheet minus the first 3 rows, but I have no idea how to do it. THanks

Thanks everybody, all versions are appreciated!

I need to add a line of code that will select the entire row of the currently selected cell in Excel. Thanks!

JPMontreal, That works perfectly! One more thing if any of you know how its done. My worksheet uses 'freeze panes' so that the field names are always at the top. Is there a way so that the chosen date is scrolled so that it appears right under the freeze pane?

In my Excel workbook I have a Date column. I need a macro that runs when the workbook is opened. It needs to do the following: 1. Sort the Date in Ascending order (I can do this) 2. Go to the Date cell that has the closest date to today's date (current date) I can get the macro to sort, but I...

My form has a button to run a query, but if I enter my info on the form and press the query button, the information isn't included on the query. To get it to work I have to go to another record, then back to the one I was on, and then I can get the correct query. Anyway to have it update...

IS there a way to add the record select buttons to somewhere else on the form besides them being at the very bottom?

wemeier, I appreciate your help, I thought your last suggestion would work, but i still get a box thats asks for parameter value. Any other ideas? Does it make a difference that the subform is on a TAB?

OK, Here is some more info: Screenshot is attached below. I have one main form called [frm_Main Page], and as you see below I have tabs setup, and each tab has its own form in it. For example, the Fees form has [frm_Fee TAB] in it. I currently have the above suggestions in the criteria, and I...

I tried those ways mentioned above, but when the query is ran a box pops up asking for parameter value. If I type in what I want it works, but I need it to work automatically.

I have two tables. The primary key in the first table is 'PrjName' and it has a one-to-many relationship with the corrsponding field name in the second table. Everything works fine except when I want to run a query. I have a button on the form for the second table to run a quesry. I need the...

thanks, works perfectly

I want to use Microsoft Date Picker control to make it easier to pick dates. How do I get the date that is picked to become a value in a table? Thanks