Search results

OK, the db on the sever, I have the databse with the name of "Cell MFG Screen" switchbaord. I am now creating a db to keep track of manufacturing waste (which will also be on the server when completed). That switchboard is called "Cell Waste Weight". Again, I want to keep these db's seperated...

Pehaps I wasn't to clear. Actually, I was looking for a way to link switchboard to on another.

I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and...

BINGO. Thanks for the help. That did it. Looks great. Steve

OK, can't seen to get it to work. I have attached the db if you have time to check it out. I am working on a graph in. I have tried this in both the query and the SQL Statement: Query Builder and am having issues. graph name is "Report2" Also, if there is no data for a week, can the show...

Stupid question.... How do I call the funtion in the query. I never had to call a module in the past. Thanks

Thank you sooooo much mailman. Much appreciated. I'll keep updated.

Geepers Creapers! LOL No, I have never used modules before. I will see if I can get your script to work. This should be interesting. I am not a professional of Access, so it'll take me some time to figure this one out. Thanks for your help. I'll keep you informed on how I make out. Steve

Thank you for your speady reply. I do reside on the US, Upstate NY to be exact. Oh man, did I mention that I am working in the MS Access invironment? This looks like its in VB invironment. Sorry. I am looking for Access help. I am in the right location, aren't I? :confused: Thanks...

Actually, I would like to see "April 29" in stead of "22 '06" for the week of.... Thanks. Here is the sql: TRANSFORM Count(qry_Sum_Returned.CountOfFab_Fab_DataId) AS CountOfCountOfFab_Fab_DataId SELECT (Format([Fab_Date_Recd],"ww"" '""yy")) AS Expr1 FROM qry_Sum_Returned GROUP BY...

Trying to create a graph, but instead of having the date of results, I'd like to group the data by the "week of". For instance, the week of (May 29, 2006). What is the code for that format that i'd use in the query. Thank you in advance. sk

First off, its been a long time since I have been here (since sometime in 2003 LOL), partly because I didn't have to create a new db in a while. Now, I have been handed a project and come across something new. OK, here is what I want to do. I would like to be able to dump data from an Excel...

Oh yea, I forgot to give the info. Query is: q kleintest Form is : Search Report is: Cell MFG Tests I'm sure you would have figured it out. But I just wanted to be as clear as I can. Thanks again, Steve

I am trying to create a chart from a query. When I go through the "Chart Wizard" and before I can finish, I get this error, "The Microsoft Jet database engine does not recognize "[Forms]![Search].[Combo0]" as a valid field name or expression." I tried to rebuid another query and that doen't...

Never mind, After working it further, I was able to figure it thanks to all for your help. A special thanks to SforSoftware. Have a great holiday weekend. Steve. P.S. I love this forum

SforSoftware Where is the "On-Fucus-property"? I was able to locate "On GotFocus", but have no idea where "on-Focus-property". Where could it be? Thanks, Steve

Anyone have ideas?? I really need to close the loop on this one. Thanks Steve

Darn ghudson I tried your method. However, it does not seem to work with subforms. Any other ideas?

In form view, I am trying to list product components (from the "Drop Down Box") associated to a particular product. The problem I am having is when I go a new record and select a different product; I get the same components from the last product I had previously inputted. In other words, the...

AncientOne Thank you for your help. I totally overlooked that. thanks again Steve