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...

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 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...

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 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...

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...

I'm using MS Access 2010 and I have a bunch of Send Object emails that reference tables and queries and sometimes the attachments contain no data. If "no data" record count=0, I would like to send the email attachment, but in the subject line indicate some additional text indicating "no...

I have MS Access macros that emails information from tables and queries as attachments. Sometimes the data is blank, do you know of any options in which I can prevent the send object from sending the email attachments if the data is null? Thank you!

I have a field called "F1", below is an example of what one of the rows looks like. In MS Access query I want to parse out field "F1" into 2 different columns in my MS Access query. Column 1 the email name, the field is divided by the left and right arrows. Column 2 everything before the left...

Is it possible to perform a make table query that includes the date in the table name without having to type in the date? For example if the current make table name makes tbl EMPLOYEES, can I have it include the date like: "EMPLOYEES 2012-04-20" Each time I run the make table I want the...

I have been struggling with converting my "start_time" field that is stored as text to a time format of "hh:nn" in my query. In my query I put the following expression to try and convert from text to time value, but when I do the query reflects 00:00 for all records. Expression...

Hello there, I appreciate this help center, I use MS Access quite a bit to manipulate data and I come to this site to learn new things. I really enjoy working with MS Access. I'm from rainy Portland Oregon, this time of year is difficult but the summers are awesome.