Search results for query: *

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...

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...

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

I have a form with several option groups. If a user selects an option, without selecting the limiting criteria (in a related combo box), it displays a message box instructing the user to limit the criteria. I'm getting stuck on how to clear the radio button from the option button (since...

Is there a way to e-mail a report (using Outlook 2000) to the person who filled out a form, as well as to a distribution list? I currently am using a Macro to SendObject to the distribution list, but am confused how to e-mail a copy to the user as well. For example, if Sally Jones filled out...

Hello! I am using the MultiSelect Property in Access 95 to allow users to select multiple items in a bound list box. I know that coding is necessary so that it combines the items into one field, but am unsure how to do it. I have reviewed the MS site, which gave an example that didn't work...

Hello everyone! Can anyone tell me how a user can select multiple items in a form's list box (and have it save to the related table)? Thanks in advance for your assistance! --Angela

Does anyone know how to group data in a form? I have a query that lists managers and agents like this: Mgr1 Agent1 Mgr1 Agent2 Mgr1 Agent3 Mgr2 Agent4 Mgr2 Agent5 and so on.... The form is filtered by the Mgr, and what I want is for ALL their agents to list instead...

I am trying to set the current date as a default value in one of my text boxes on a form. Normally, I could simply enter =Date() in the control source field. However, since I am writing the form data back to the table, I am unsure how to keep the original table name in the control source and...

Hello! I am trying to create code that looks at the time and highlights it if it is either under or over the goal times indicated. Here is my code in the "On Print": Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim goal As Date goal =...

I am creating Macros to export some Access table data into an existing worksheet (for graphing purposes). If my field is 3.9%, it transfers into notepad as .03 and therefore converts in Excel as 3%. I have tried setting the table decimal point properties to as many as 5, and it still doesn't...

In my linked table, there is a general date field (7/23/01 10:59 AM). I am writing a query for a real-time report & therefore, need to query the fields whose date criteria equals the current date. I originally tried =Now() which didn't work. Entering #7/23/01# works, but it doesn't serve us...

I have a subreport in one group header and it needs to be averaged in another header? Is this possible?