Search results

Something along the following lines should do it. {Value of Field}: IIf(TaskId = 2, "Admin Time","Investigative Time")

Nah, he's good. I just hang around and catch some of the adulation, as it washes off. :D

You could add something like the following to the AfterUpdate event of the field the person is entering the number into. If DCount("name of field in table","name of table","name of field in table = " & [Forms]![name of form]![name of field]) > 0 Then Msgbox "That number already exists"...

Have you tried DoCmd.SetWarnings False DoCmd.OpenQuery "qryDeleteEmptyCourses", acViewNormal DoCmd.SetWarnings True I think that should work.

Additional Question I think this post is the closest to what I need, so I'm hoping someone can elaborate a little. I'm not not sure if this method is what I should actually be using. I have a number of saved queries. At present, the users view reports as snapshots, each one created based on...

Perfect! I knew there'd be some easy way to accomplish it. Thanks a lot.

I use something like this: If MsgBox("Do you want to save the changes?", vbYesNo) = vbNo Then Me.Undo Me.Close Else ‘Whatever code currently saves the data Me.Close End If I'm sure there are many other ways to do it...

I have a number of reports that have as their datasources either a saved query (say, 'Query1') or an actual SQL statement (say, 'SELECT IDNumber FROM Table1 ORDER BY IDNumber;'). I want to create an Excel spreadsheet based on each report, but having applied one or more additional filters to the...

Thanks for the reply. Unfortunately, the grouping names are aren't differing. I end up with: Group A -$66.00 Group A $100.00 Group B $77.00 and so on. Anyone else with any suggestions? getting desperate here, folks. :(

I've been using the following query: SELECT [qry_1].Month, B_Division_Group.Grouping_Name, Sum([qry_1].Month_Client_Count_from_B) AS Monthly_Count, Sum([qry_1].Month_Assets_from_B) AS Monthly_Total, Sum([qry_1].YTD_Client_Count_from_B) AS Yearly_Count, Sum([qry_1].YTD_Assets_from_B) AS...

Unfortunately, this made no difference to the characters. Unless anyone has any other ideas, it looks as though I'm starting the report from scratch. :(

Please don't say it's the dreaded 'c' word! :D I've tried compact and repair, recreating one of the controls, and copying the whole report into another Db. I think iyou're right and mporting into a blank may be my only option. One question, do you know how I'd keep the various drop-down menus...

I have a report in which the right hand data comes from one query and the left is found from a second query. As of about an hour ago, I'd finally got the whoe thing working. Now, however, whenever I open the the report - preview or print - the left hand numbers are all displayed in Chinese (I...

I think that's exactly what I'm looking for.:D Thanks a bunch - you've saved me a lot of query-by-query manual checking.

Thanks for the response. If only it were that simple. Unfortunately, no relationships have been declared in this way.

Is there an automatic way, within Access, to see all of the relationships between various queries? I've inherited a db with no documentation and many interrelated queries. I'm about to start 'mapping' it by hand, but was hoping to make my life easier.

You learn something new every day :D

For displaying the date, you could use Format(fieldname,"DD/MM/YYYY"). It will still be stored in the table as 1/1/2006, but look like 01/01/2006 to the user.

You should be able to adapt this to suit: You don't need to use all of the criteria, just remember to include all commas prior to each one you do use. Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to continue ?" Style = vbYesNo + vbCritical + vbDefaultButton2 Title =...

Whoever of the two of you owns the most vineyards, surely? :confused: