Search results

I have an issues database that has field "Issue Number" as the primary key and is set to autonumber. I would like to create an unbound text box that when an issue number is entered and you press enter, it takes you to that issue. This would work similarly to the record number field on the...

Thanks. I had the sort on the query. I placed the sort on the report and now it's fine. Any comment on why the report would just suddenly decide to rearrainge the order?

I'm tracking issues on a db in Access 98. I have a report that displays open issues. I set the query the report is based on to sort by issue number in ascending order. I wanted to display the number of open issues so I created a field with the following as the control source...

No reason, Rich. I had tried numerous combinations, many of which included Me., the above was the last. The following works, but I need something that will make the data stand out more. If CPT = "99251" Then [CPT].FontUnderline = True Else: [CPT].FontUnderline = False End If I'd...

Is it possible to prevent the same combination of entries for a group of field as in other records? For example; I have a db with four fields (record number, A, B, and C). The entries for record #1 are [A]: Blue, [B]: Green and [C]: Red. Record # 2 allows [A]: Blue, [B]: Blue and [C]: Red and...

I use the following on a form to conditionally format a field. If Me.Submitter = "Black, Stephen" Then Me.Date_Submitted.BackColor = 255 Else: Me.Date_Submitted.BackColor = 8421376 End If I'd like to do something similar on a report. I've tried different combinations and approaches...

Thank you, Pat. I had been working the issue the way you are suggesting, but everything I had tried failed. I'm not familiar with writing the code you mention above. Could you provide more information on the code itself and where/how I should use it? I'd be grateful. Thanks in advance, Stephen

I have a report that's based on a query whose form has an option group. The Options (and Values) are N/A (0), Yes (1) and No (2). I have the option group set to store the numeric value in the table. I need to report the average of the option group without including the N/A's. I need three...

Thanks for the heads up on the code. As for updating; I have an autoexec macro running the update query. It works fine (which is to say that my update field=now() reflects when I open the db), but it's as though task scheduler is not opening the db, even though it's not reporting any problems...

Thank you both. The sample was very helpful. I've created the AutoExec macro (for learning purposes, eventually I'll convert over to vba) and it works fine whenever I manually open the db. However, even though task scheduler is stating that it opened and closed the db, and reports no problem...

Thanks, Tom. I'd like to stay away from macros all together. I understand MicroSoft wants to eventually do away with macros entirely. Everything I've done up until now has been in vba. However, I have no idea how to get this done using code. You mention other tools to handle "live" data...

I have an update query that I need to run on a very frequent basis (including nights and weekends). I can run task scheduler, but I'm not sure if I can drill down to the update query to make that run off of the scheduler. I'm thinking of using a macro for this. Can anyone reccomend a sound...

Bingo! I put in the control source instead of the name. Thank you both, Wh00t and Rich.

With this I get a message box prompting me to enter a parameter value for the field. If I click OK without entering anything, my form goes blank. If I enter any data (tried *, fragments of names, complete names and then copied and pasted a known name) the form goes to a filtered status but...

:) Tried that too. I was getting the same run time error, highlighting the first line in debug. Quirkey, huh?

I'm using the field name as opposed to the control source name. This is what I have now: Forms![ISO Referral form All].Filter = "[PhysiciansFullName] = > ' '" Forms![ISO Referral form All].FilterOn = True And I'm getting Run Time Error 2448. When debug, it highlight the whole first...

I have a quirky problem in '97. Being a self taught beginner I often rely on the properties/methods and contants lists to help me finish statements correctly. More frequently though, the lists are flashing so quickly I can't read or scroll through the list. Even when I right click and select...

I'm getting Run Time Error 2448 "you can't assign a value to this object" with the brackets.

I had tried that also, still get and error.

I'm on 97 also.