Search results for query: *

Hello, I need help in coming up with a formula for the following: I want to add C2 and B3 and have the result in C3. However if B3 is zero, then the result in C3 should be zero. Any help is appreciated. Thanks Paul

Hi, I have a report that has two group headers besides the page header. The detail section has fields that overflows to the second page. When I preview the report the headers stays on one page and the details starts on the second page and there by leaving 3/4 of the first page blank. Is there a...

Hi, I have a data entry form with five fields (name, address, city, county, state). 90% of the users will have only one record to enter but the other 10% might have more than one. So I created a second set of fields in the table (name1, address1, city1, county1, state1). Now in the data entry...

Hi: I've created 2 vbYesNo MsgBox one to save the input and second to print the input. If I chose not to save the input I want to form "frmOpenAsgmt" to automatically close when I click the No button, how can I get it to work. Any help is greatly appreciated. Below is the code where I get...

Hi, My database has an Inactive Shut Down form that pops up if there is no activity for 30 minutes and closes the application. I'm trying to do a print screen of an input form. The form as a vb YesNo button to print. When I click Yes the first time it automatically prints the Inactive Shut...

Hi: The date field of an imported access table looks like this: 1010811; the format is 1yy/mm/dd; I want to convert it to the standard format of mm/dd/yy; so it reads as 08/11/01 Is there a way to do it rather than re-entering the data? I tried exporting it to EXCEL but that did not help. I...

thanks for the link, but I'm getting stuck on the line below: Scrolltext = Mid([Strfield], astr, Len([Strfield])) & " " & Left([Strfield], astr) The code from the link is: 'start paste Private Static Function Scrolltext(strfield As String) As String 'call from on timer event Dim astr...

Hi, Is there a way to have a scrolling text in a form? Thanks, in advance. Paul

Hi: I need a text box that can hold 500 characters. Therefore, I created 2 text boxes with 255 characters each. There is a possibility that both text boxes will be used in every instance. Therefore, in a report is there a way to supress the blank text box. The report will have records that...

How do I get Access to search an address database and send an email on a specific date? The table has the email addresses, subject etc. For example, an automatic reminder email into his Inbox, maybe a few days before the due date. or an automatic "happy birthday" message on a client's...

I have a database that is being accessed by almost 80 users across the country for the last couple of years without a hitch. A copy of the front end mde file is on the user's computer. The users also have an auto updater so that as and when I have a new version on the server it automatically...

Hi: I created a db with 6 tables. I did not create any relationships. Instead, I did the individual relationship in each query. I split the db as the front end and back end files. When I did a performance analyzer on the front end file, it suggested creating relationships. I clicked OK and...

Hi: I created a customize toolbar "Report Utility" so that the users can print and/or email (as attachment) a report. The toolbar works fine but appears on every screen - both forms and reports. I would like the toolbar hidden when the user is in on any forms but to appear on all reports. I...

I have two tables - tblCourses & tblUsers: tblCourses is only for reference purposes – to help the user to select a course. All records are stored in tblUsers. The fields in tblCourses are CourseTitle, CPEs, startdate, enddate, cost The fields in tblUsers include all the fields in the tblcourses...

I have a field where the user enters codes like A1P or A2C or A3B. The code represents A1P - Online; A2C - Classroom; A3B - Self-study; In the report, now it shows these codes, instead, I would like what the code represents. The report should replace A1P to Online and A2C to Classroom etc...

I need a message to pop up stating that there are no records, when there are no records to show in a form. The record source for the form is a query.