Search results

I think this is what you are asking. The report will have a "No Data" event property. You can attach code to that property so if the query running behind the report does not return any records then you can have a message box come up or something and cancel the running of the report if you...

Just a couple things to check with join errors. Make sure the datatypes are the same (text to text, etc). Make sure the field lengths are the same (usually this will not matter, but if you have data that is too long on one side it might fail). Since you are using a left join make sure the...

EmmaJane - It sounds to me like you have more than one issue going on here. It would not be very difficult to create some code that replaced numbers with a letter equilivilant from a code table. I guess my concern is that if you use a simple code to convert the numbers so that the people who...

You are going to need some code that will fire with the "on Current" event of the main form. The code will need to call the dataset for the subform and loop through the records to see if they are complete (not sure what that will mean to you - some fields populated or something). Have the...

I took a look at your database, but the function in there is not the same as the function you posted. Both of the functions seem to have issues, but together they look like they should work. Try using the select and from clauses from above combined with the where clause that was in your...

One last thing - once you have the grouping levels in place then in grouping level footer you can count the number of people in a text box. To count the people in a group use =Count([ID]). Where the ID field referred to in the expression is a unique identifer for each person. GumbyD

Sadie - Is this two separate reports on just one? It sounds like two. Anyway if you have an age field (which by the way is a bad idea because anytime anyone has a birthday you have to go in an change the data - if you store birthdate you can calculate age using a datediff function) back to...

The only thing I see wrong with this is that you do not have an 'End Function' line on the code. I put the code in place here and it worked great. Is the system giving you an error message of any kind? In your query you just need to put in a new field like: DayCount...

It sounds like your criteria is not set. Can you post the SQL for the query? GumbyD

In the "Row Source" property of the combo box select a query that you created the has the code and description in it. Then in the "Column Count" put 2. In the column widths property put 0,2. In the "Bound Column" put 1 (that will bind the field to the code). In the "List Width" put 2.0. If...

When you say how can I "use ssdbgrid?" Do you mean how do you get to the control or how do you use the control? if you just want to know how to access the control then from the tool box select the "More Controls" icon and it should appear in the list. If you want to know how to use the...

Check the datatype on you field and make sure it is set to date/time. If you have set as a number of some sort it will change your data to fit the datatype. GumbyD

Wow are you really still using Access 2.0??!! The only problems I have run into are with code and tab forms. Sometimes you have code issues because of the updates to the code library, but unless you have a lot of code I would not worry about that too much as Microsoft was pretty good about...

sadie - I read your post, but I am not sure what the issue is. What data do you have (ie Birthdate? country?)? What do you need to display (for example I need to group up my cases by county and then by age with my age groups being 0-6, 7-11, 12-18 etc). Have you created a query to base the...

I think you can get what you want by using a dlookup funciton to access the field from the unrelated query. The expressioin on your report would look something like the following: =([SumOfCostPerPerson])/(dlookup("[MyField]","[MyTable]") good luck! GumbyD

Garyj - I think I can assist you, but I need more information. Which one of the date fields that you have referenced cannot be on the weekend? Since you are comparing two dates if a date falls on the weekend do you want to compare the following Monday's date or the preceeding Friday's date...

Try this expression: Right([Field1],Len([field1])-InStr(InStr(InStr([Field1],"-")+1,[field1],"-")+1,[Field1],"-")) You will need to replace "Field1" with your field name. GumbyD

Try this code: Private Sub Form_Timer() Static strMsg As String, intLet As Integer, intLen As Integer Dim strTmp As String Const TXTLEN = 36 If Len(strMsg) = 0 Then strMsg = Space(TXTLEN) & " from left to right " & Space(TXTLEN) intLen = Len(strMsg) End If intLet = intLet + 1 If intLet >...

JWT - The reason you are getting the error is because you are using the Cdate function over just part of your expression. All of the output of your expression must be able recognizable by Access as the same datatype - so it needs to all be date values or all be numbers etc. namliam is...

It looks to me like you have an extra SUM in your expression. The the following: =(Sum([PAYING CASES])) / (Sum([TOTAL CASES])) That should work. If it does not try naming the other two sum fields that you have already created and then doing the division with the two field names (ex...