Search results

xProjNo = Me.cboProjectNo.Column(1) 'This pulls in the number not the ID xProjectName = xProjNo & "OverallProjectGroup" xFullName = xProjectName.FirstName & "' '" & xProjectName.LastName AS NameOfAlias cboEmployee.RowSource = "SELECT ID, " & xFullName & _ " FROM " & xProjectName & _...

I'm trying to use the first box to give me the number to place in front of the string. If user selects 101 then: 101OverallProjectGroup If user selects 702 then: 702OverallProjectGroup I think my syntax is in error with attaching all the strings. If I dump in a msgbox calling for the...

I'm trying to code a combo box that based on a previous project selection the combo box will list items from that project. Form: The form allows the user to select a project number. Once this project number is selected I want the next combo box to pull info from that project's table...

Huh? A little bit confused by your comment. I don't have StrProj in the OpenArgs section because I have something else in there. Over View of DB: User opens DB User enters username/pass on login form This opens up ProjectList (form), (OpenArgs set to project number) This opens up start page...

StrProj = "OverallProjectReport-" & Me.OpenArgs When I use the msgbox it pops up with: OverallProjectReport-101 The error is on the DoCmd part: Run-time error '3011': The Microsoft Office Access database engine could not find the object 'OverallProjectReport-101'. Make sure the object...

I'm trying to find a way to call different project tables to easily feed into reports for the end user. Forms/Reports in front end db and Tables in back end db. All the tables will be called by same name, but have the proj number attached to them. Even if I attach the number without using the...

I've developed a database that starts with a user login and then allows the user to select a project number. The project number is then used as an OpenArgs to concatenate with a string to form a table's name. I'm having a syntax error with the following code: Tables: OverallProjectReport-101...

The filter is used due to what is in the Table: OverallProjectReport (Table) OverallProjectReportConvert (Query that converts table info) So user can select a conversion report if they wish That's why I use the filter statement. The OpenArgs is pulling in the correct number based on which...

It gives me the following: "OverallProjectReport-101" for the StrProj value and gives me an 3011 Error

I've developed a database that starts with a user login and then allows the user to select a project number. The project number is then used as an OpenArgs to concatenate with a string to form a table's name. I'm having a syntax error with the following code: Tables...

When you said DLookup you helped turn the light bulb on. I just set up a query with the fields I needed and ran a Product calc on it and then ran a DSum on the Product Field in the report. SumProduct function completed, thanks again.

I'm familiar with the & making two things placed together and I can make it concatenate if I run a query from the table and do it there. My problem is within the report when I'm pulling fields from a table how to concatenate two fields. The reason they're not together in the first place is due...

txtFinalXposition = WorksheetFunction.SumProduct(arg1, arg2) / OverallWeight When I place [XLift] and [Weight] into arg1 and arg2, the result is equal to 0. XLift is pulling from a table and Weight is pulling items off a table to the report to auto fill it. When multiplied and added...

Trying to do the SumProduct in a Report. My question is how do you type it in VBA to work. I've got the following fields coming in XLift and Weight. If I check the box to allow Excel worksheet functions I've come to this: OverallWeight = Sum(Weight) 'Note I've got the total here already...

That took care of it. Thanks. Was going to ask a question on concatenating as well. When you pull in a Field from a table can you add a string to it? For example: Add existing field car Pulls in car and then add extra text: Ford Ford - 2007 so Ford would be in the field and "- 2007"...

Is there a way to make the Page Header start on a certain page and go from that point forward? My Report Header is a bit long and goes into two pages and I want my Detail to come in at the middle of the page not my Page Header. So is there a way you can make it Report Header-Detail-Resume Page...

I got it to work with a "unique" coding design, which I highly doubt is anywhere remotely close to the "best" method. What is the data type for the "Results" field you're referring to? I understand how you link temp/material through it's primary key to the junction table. The only think...

JANR thanks for the help and I understand the coding and other tips. My major concern is how the coding will act with the following: InputTemp = 500 (500 is one of the temps in the temp table) This will work and get the value InputTemp = 505 (this is suppossed to go to the next value 550)...

Curious what the coding would look like for an equivalent to the "match" function in Excel. I have a table for MaximumAllowableStresses for metals, and based on what the user selects as a metal and temperature it looks up both in a table and gets the value needed. The table for...

I got it working used: Me.txtLineSize = DLookup("Sizes", "tblLineSize", "ID=" & rs!LineSize) Totally forgot that I could compare the "ID" number I currently pulled from the original storage table. Thanks for the help and apologies for my mental block.