Search results

I have been trying this out and so far I like this one. http://www.mywebexpc.com/index.php

Works perfectly thank you.

Is there a way to turn off the right click so I can have it show something else instead of showing the context specific menu. It does show what I want it to, but I don't like have the menu come up with it.

Well duh that was easy, I had seen that before but didn't even think about it, I guess I can blame that on lack of sleep, but I think it's just stupidity. Thanks...

Any body know if there is a way to make a query to get all the field names in a table? I have a dynamic query that, from comboboxes, I select the table name, field name and the critiria for the query. I want the field name box to show what fields are in the table to choose. Thanks, Matthew

I finally got it. I stumbled across this site. Great info and very well explained. http://www.fontstuff.com/access/index.htm

If I read what you are saying correctly, I'm not having problems referencing the subform. It seems access is having problems inserting the subform with dynamic fields. I get an "Application defined or object defined error". I guess I am also kinda looking for a better way to do what I am doing...

I hope I can explain this and make any sense. I am trying to make a form where I can choose in a query what fields I want displayed. I have a combobox that I choose the table, and another combobox that list the fields that are available to view. So I get: tblZincWastewater.Analyst...

Thanks for the help. Haven't had a chance to to mess with it, hopefully tonight. Thanks again...

nope sorry for the confusion. I need the data from the AIM_N7089 column with the most recent date in the date column that has data in the AIM_N7089 column. In other words if today has data in the AIM_N7089 column I need that data, if today and friday do not have data in the AIM_N7089 column but...

Thanks, this is an example of what I have, ignore the dashes used for formatting. Rec_Date----- AIM_N7089----- AIM_N7090----- AIM_N7091 12-18-04----- ---------------- 3.4------------ 4.4 12-17-04----- 2.6 ------------ 3.5------------ 3.4 12-16-04----- 2.3 ------------ 3.4-------------4.0 So...

Sorry, let me see if I can explain this a little better. There is data entered everyday in some fields but not the in the field that I need to find the most recent. It might have data 3 days in a row and not have any for the next 2 days, but there is a new record made everyday so for today that...

I need to get the most recent data from a coulmn that is not null. The table is dbo_SouthVariable1 and the coulmn is AIM_N7089 and the date column is Rec_Date. I tried using DMax but not getting it to work for me. I hope you can understand this, I'm not very good at explaining what I mean. :(...

I need to make a report that shows everyday of the month. My problem is that I do not have data everyday. Is there a way to list all the days of the month and fill in the data on the days that there is data for? Hope you can understand what I need. Thanks, Matthew

There is a utility here, find and replace, that will do what you are looking for. I have used it and it works great.

I am trying to make a query for a chart that includes the following fields from a table tblMetals: AnalysisDate AnalysisName SampleName ReptSmpmg ReptBkgmg I need to do some calculations for the chart as follows: Result= ([ReptSmpmg]-[ReptBkgmg])*100/1 Average= Avg(Result) Std= StDev(Result)...

Thanks for the reply, I thought more about it after I posted and thought about that soultion too. Thanks again, Matthew

I have a form that is populated via an append query with 28 new records that have different sample names entered into the SampleName field. I need to have "-----" entered in to some of the fields depending on what the sample name is. I would like this done automaticlly when the form is opened...

Just what I needed, thanks. I searched google and here but wasn't able to come up with anything. Thanks again, Matthew

I'm getting better with VB, but not good enough. Can someone please help me figure out how to close all open forms, if that is possible. Thanks, Matthew