Search results

Hello Everyone, I am using Access 2007 & trying to update a database to include a check & balance. Currently a user enters their name into a form, selects a check box (Pass or Fail) & clicks a save button. Real simple form. The actual testing is performed on a standalone piece of equipment...

Hello Gentlemen, I have a Word doc with some form fields. I would like to save the form with a file name based on the data entered into the form fields. Example: Field 1: Job # Field 2: date File name to be saved as: Job# date.doc Thanks in advance for your help.

Hello All, I have a strange error that I can not figure out what is triggereing it. I have a subform with 2 required fields. As I am typing data into the first field an error message window prompts specifying the data in the second field is required. Why is this premature error coming up...

Hello All, I was looking for assistance in creating a feature in my form. I would like for a subreport to open based on a desicion made in a form. Example: If an item was classified as bad , I would like for a subform to open & require additional details. The required details are specified...

Hello All, Some back ground on my DB: 1 Main Table fed by many sub tables. The sub tables are all lookup tables to create drop down boxes for the main table. For the sub tables, column 1 is the ID# & the second column is the actual data. I made sure the bound column was 2. When running the...

Hello All, I am interested for my query result to be exported to an Excel file. What code is required to prompt the user to define a file name. There are multiple people in this DB & multiple PCs so a defined file name or location is not possible. Thanks in advance

Hello All, I have been away from Access for a while & I forgot how to a create a query where in a Datasheet view I can enter data & it will update the table. Thanks in advance

Hello All, I apologize for the question as there are many threads on this topic already, but the method for the multi-select list box is not clear to me. What do I have to do in order to make a multi-select list box? My query is looking for the entry on the form but I do not know how to present...

Hello All, I was wondering if its possible to open a form & display a query calculation on the form? Here is another curve ball, the query is based on a field on the same form. Any ideas or suggestions?

Hello All, May someone provide me with the most simple method to lock one field on a form after its data has been entered. Is it a simple After Update event procedure? Thanks in advance.

Hello All, I was intersted in a text box entry on one form populating two different tables. The one field in both tables are identified by the same name. Is this possible? :D Thanks in advance.

Hello All, I have a table with two fields, one named Class_Name & the other Employee. How do I create a query that defines which employee has not taken a specific class? :confused:

Hello all, Why is it when I enter data into my subform it prompts me with a message stating its read only. There are no queries, both main & sub forms have "Enabled" set to yes "Locked" set to no. The 4 "Allow" properties are set to yes. DataEntry set to no. One realtionship set one to...

Hello All, Typically when I enter the design view of a form, the subform shows its data fields. For some strange reason, when I click on design view the subform now opens as a large white box with no data fields. May someone explain this anomaly to me? Thanks in advance

Hello All, I have an error message that states: Run-time error '3075': Syntax error (missing operator) in query expression '(DATE OF CLASS between #06/01/2007# And #07/01/2008#)'. Going into the debug, the last line of the code is highlighted DoCmd.OpenReport strReport, acViewPreview, ...

Hello All, Here is a simple question for someone who knows the answer. lol! I have a sub form on my main form. During Print preview of my report, I would like each sub-report entry to be numbered 1 thru ... however many entries on the sub report. Any ideas on how to do this? Thanks in...

We have a report coming in access db making a bar chart. Would like the data labels at the bottom of the bars to show a 2 decimal place % (ie:15.84%, 15.22%,....) for all bars. It is a top 10 pareto, source data is from a query and when we try to put the % in as an &"%" at the Row Source box...

Hello All, Here is a really simple question for someone who knows the answer, lol. I want to enter a statement on my form that prevents the entry of specific text based on a previous entry. For example: One field named "Make" may have the entry "Toyota". If Toyota is typed in that field...

I created a report using the wizard. During the setup, it asks for the fields within the table to be repored on. I've added a new field into my table & now I would like that new field to be in my report. When I click on the Field List icon on the report, my new field is not there. How do I...

Hello All, Based on one entry into a form, how can I have the form auto fill other fields that are related to that first entry? Thanks in advance!