Search results for query: *

I really appreciate your help, Roy, but it still is highlighting all the fields, even when there is data in the [RippedName] field. Any help? Is it possibly because the RippedName and the AppName are both in the detail section, and the report has already formatted before seeing if the...

Well, that made it past the debugger... but it's not doing what I want it to do. Basically if the field RippedName is Null, then I want the field AppName to be highlighted (therefore the change in backcolor). Right now the code you recommended is highlighting everything even if the field is...

Can anyone tell me why this code is not working in the OnFormat code for the detail section of a report? Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me!RippedName Is Null Then AppName.BackColor = 12632256 Else End If End Sub The debugger is stating that an object...

" I am currently developing a webpage for my brother's car dealership with FrontPage 2002. I have created a credit application page to interface with the corresponding database. I have uploaded the database to the server, but when I try to click the ok button (where it should send the data...

HELP! I haven't worked with MS Access in a very long time, and am getting stuck on the most simple problem. I have a form which is tied to a table. When the form opens, it populates the fields with the first records data. Since I have a combo box [cboPrimaryCustomerName] which searches for...

I appreciate everyone's help.... but, I have a custom cursor (that I just happened to name crosshair -- after the bow crosshair) that needs to be used. Any help??

Unfortunately, that is not what I was thinking... I need to figure out a way that I can have a custom cursor be used on the page. I have drawn & saved it in my Windows cursor file, but cannot figure out the HTML to have it on the webpage. In other words, I don't know how to make a cursor...

Hello all!! I am developing a website (FrontPage 2000) in which the client wants a crosshair cursor once the website is opened. Unfortunately, I don't know how to do this. Can anyone help me with the HTML coding? P.S. I only want the mouse to change while on this website, so I will need...

All you need to do is insert a Save DoCmd into your form's "on close" property.

Actually, I want the year to be constant. So the first record would be contact 2002-1. The second, 2002-2. The hundredth, 2002-100..... Any help?

Phil, You will need to be a little more specific if you want this answered. Let use know if you need assistance with writing the code or setting up the command. Then someone will be able to help you. Angela

Dick, I can't explain why it doesn't work, but I would have you check your installation of XP. When installing, choose the Typical installation (which includes the label wizard). Check your add/remove programs in the windows control panel for the label wizard. If it is not there, you can...

Robert, Access help topic "change the starting value of an autonumber field" tells you how to accomplish this with a query. Hope that helps. Angela

Doc, Not sure I totally understand how your tables are set up... If you have a table for each test, why can't you create at least 6 required result fields? For example, for the gestational diabetes table: TestName Text Result1 Number Result2 Number Result3 Number ..... If...

Hello all! I haven't been working with Access 2000 much lately, and have forgotten some of my old "tricks". I am designing a contact management DB which needs to have the an automatic contact id. I want the id to have the following format: current year - integer...

How can I make an update query that updates on the first of each month? (I know how to do it every so many days, but that doesn't work for my need.) Thanks in advance for your help!! --Angela

The best to do this is to create a report that has all your data in the report header. Then,use the chart wizard to create the type of graph that you desire (the wizard really makes charting simple for first-time users). At one point the wizard will ask you to arrange the data according to...

In the control source of the combo box, reference the tblCompanyName (if it is available in the related query). If it is not available from the form's control source, use a syntax similar to this: SELECT DISTINCTROW [Company] FROM [tblCompany] ORDER BY [Company] This will pull the company...

Why not create a query from table 1 and table 2? Then use that query as your control source for the form.

Let me know if you ever solve this problem. Unfortunately, all of my research as the mgr of the IS department has proven that reports do not convert from any previous version of Access. Good luck.