Search results

Does this webpage help, or this webpage? Or, if you click on Tools -> Options -> Forms -> set the form template to 'Normal' (without the quotes). For individual forms, go into the form design, Click Edit -> Select Form, Click View -> Properties -> Format tab -> have a play with the picture...

Hi Change the control source for your meetings subform to the Meetings table instead of the SQL statement you currently have. What are you trying to do with the 'relationships' and 'services'? Can you explain how this is intended to work? Andrew :)

Hi Can you post a sample database which shows the error? Andrew :)

Hi Can you describe examples of good and bad data? Whilst it should be easy to identify data that doesn't meet validation criteria, it might be harder to identify data that doesn't conform to input masks (but I'm happy to be proved wrong on that). My initial thought is to import the data into...

Hi In your form you have 4 fields : 'CriteriaText', 'CriteriaKey', 'CriteriaNB' and 'ExceptionNB' into which you can enter data. 2 of these fields are stored in 'tblCriteria' (i.e. 'CriteriaText' & 'CriteriaNB'), so when you try to enter data into the form it is trying to add new records to...

Hi Joe When you say 'mail merge' are you referring to the mail merge that you do from Excel into Word? Or are you referring to a report from Access? (given you had this in the Report form). It would help if you provided some information on where the data is stored and also what you are trying...

Jon, Don't get me wrong, that is a pretty neat query but I think you misunderstood my question....maybe I will have to be a little less subtle. In your post you used different table names (compared to the Becky's table names) so Becky cannot copy and paste your SQL into the database without...

I'm curious as to how you manually enter this into the query design screen given you used different table names : -Sum([FormReceived]=1) AS [Count of FormReceived=1] How would you key that in? Exactly as you wrote it? Andrew

You're welcome. To stop the users editing or deleting records, go into the form design, click Edit -> Select Form, Click View -> Properties -> Data tab -> set AllowEdits, AllowDeletions and AllowDeletions to 'No'. I'm not an expert with VB but a quick and dirty way of refreshing the screen is...

Hi Toni Your description is almost the exact design you need for your query. Create a new query, add your table, click View -> Totals, add the fields you want to see on your report (i.e. CCA Number, Supplier, requisition, assetnumber), under requisition and assetnumber change 'Group By' to...

Hi As a workaround, how about using this in the OnClose event of the report? Private Sub Report_Close() On Error GoTo Err_ErrorHandler DoCmd.SelectObject acForm, "MyFormName" DoCmd.Maximize Err_ErrorHandler: Exit Sub End Sub Be sure to use your actual form name. HTH...

Hi Becky I think you need to do this with 2 queries because I don;t think you can combine the count with the crtieria you want. The first query includes the data from just Table_FormLogInfo where FormReceived = 1. The SQL for the query looks like this : SELECT Table_FormLogInfo.ID...

If you are relatively new to Access. let's start with something simple like searching for the records you want. We can worry about displaying them on forms later. Create a new query and base it on (i.e. add) the table that holds your imported data. In your query design screen, add the fields...

Hi Try using this instead : Format(Format(Month([DATE OF BIRTH]),"mmmm"),">") HTH, Andrew

Hi Lee Try this : DateDiff("m","01/04/" & (Year([DepreciationInvoiceDate])-IIf(Month([DepreciationInvoiceDate])>3,0,1)),"01/04/" & (Year(Date())+IIf(Month(Date())>3,1,0))) HTH, Andrew

Once you have selected an item in your list box on your form, are you clicking a button on the form to open the query? Or are you manually opening the query?

Hi I'm not sure I understand your question 100%, but if I understand it correctly, you want to select a value from a listbox on a form. The value in the listbox is passed through to a query as the criteria for a certain field. If that is the case, then in your query design screen, under the...

Hi Something like this in your query : Surname: Right([MyFieldName],Len([MyFieldName])-InStr([MyFieldName]," ")) will extract all of the data after the first space. You can then sort on that. Be aware that if an entry has a name such as "Mary Anne Smith" then it will pick up "Anne Smith"...

Hi You should be able to do this by creating 2 new fields in your table and using an update query to update those fields. In your update query, something like : Num: Left([MyFieldName],InStr([MyFieldName]," ")-1) will give you the number, and Name...

Yes the limit is 7. See the 'Form and report' section of this webpage Andrew