Search results

I have done some basic data validation on a form, but I cannot seem to apply data validation to my subtotalled column called SUM FTE. For the field properties on the Data tab I have the following: Control Source: =SUM([FTE]) Validation Rule: >1 Validation Text: Total FTE is >1 My test...

That might help, I have never done visual basic this way, so appreciate your patience with me. I added the report name to the Output Line, but I'm still getting error 2451, this time on the Str report line Sorry, but this is way beyond my knowledge base Private Sub Create_PDF_Click() Dim...

Paul, thank you so much for your reply. I'm getting a different error, run time error 2103 on the DoCmd indicates report name does not exist in Property Sheet or macro is misspelled or referes to a report that does not exist Private Sub Create_PDF_Click() Dim myPath As String Dim...

Okay, this is way beyond my expertise, I do not know visual basic at all, I'm really guessing with what I have below. I can run macro's, reports and queries, but not visual basic. I have a report that I would like to export to a folder, and I would like to include the FullName within the...

I'm trying a combo box in my form that retrieves the queries in the table. Can you help me the command button to run the query that's within the combo box? I can add a command button, I just don't know how the properties of the command button. Sorry to be such a novice at this.

My query description is a text field in my "Tbl_Query_List". I have 2 fields within this table - query name and desc. I do not have any action queries, just a select query with parameters that the user will input.

I like the look of the continous form in that I do not have to click on a small combo box and I would like to incorporate the query description, but if this is the best way I can give it a shot. So if I do the Combo Box I can place a Command button next to it, can you help me with the run...

Continous Form: query_test -this is query description test 1 query_test2 - this is query description test 2 Command Button below continious Form "Run Query" User needs to highlight query in continous form then they hit the Run Query command button at bottom of form Thanks again!

From the main form I want to display a continuous form showing the selected queries in my table called Tbl_Query_List. Below the form, I want to a Command button for the user to run and display the query results once they click the highlighted query and then they select the Run Query command...

Thank you kindly for your quick response! This sounds like the easier approach, but I like my continious form in that nicely displays the queries along with a query description, is it possible to use the continious form by highlighting the query within the table and having a command button to...

I'm really green when it comes to front end side of MS Access and forms, and I can really use your help. I have a table called Tbl_Query_List that houses the query names that I want to be displayed on a continuos form. I want the user to select the query by highlighting it in the continious...

I'm new to forms and this is the first time building database entry form . I have macro on form and it appends and deletes records only issue is that it's doing actions for all records instead of record that I'm on. Do I need to modify my queries so that it prompts for record criteria? I was...

CJ, that worked perfectly from what I'm seeing in my small testing table. Thank you!

Not sure if grid is displaying properly. I need to add "counter" to my query, below is an example, each time the empID changes I want the record counter to start over again. EmpID/DEPT/counter 10163/2110/1 10163/2125/2 10163/2220/3 35570/3150/1 35570/3120/2

Hello, thank you for your assistance! In my query called "test" I have the following fields: EmpID & DEPT, below is an example. EMPLOYEEDEPTcounter1016321101101632125210163222033557031501355703120235570313033557031404 I would like to add a column to my query called "counter" and count...

I have this working now, see below... Sub starter() Dim qdfLoop As QueryDef Dim dbs As Database Set dbs = CurrentDb For Each qdfLoop In dbs.QueryDefs If InStr(qdfLoop.SQL, "LAWSON_LHSEMPDEMO.R_STATUS") Then MsgBox qdfLoop.Name End If...

Thanks, I'm a little leary of installing software, I need to apply these updates to different PC's and different dbases, sounds like I would have to install the V-tools on each. I was hoping this was an easy request, but it sounds more complicated. I think I have something close with...

I have no experience with Access Modules which I think I need to find all the queries that reference a field, in this example: LAWSON_LHSEMPDEMO.R_STATUS I would like for the module to list all the queries for me that reference this table and field of "LAWSON_LHSEMPDEMO.R_STATUS" Is there...

Very helpful information, worked great in my database I do not recommend having this done at the airport however.

I need to find out where the field called "R_SHIFT" is being referenced in all our MS Access queries. I just need the query name so I can go into the query and change the name from "R_SHIFT" to "SHIFT" Thank you so much for any help you can offer. I'm posting this question in hopefully the...