Search results for query: *

Hi, I was wondering if there is a way to filter a row by the color of the text contained in each cell. I think if there was a way to determine what the cell text color is using a formula then it would be no problem, just use the criteria in the advanced filter. But, is there a way to find out...

Hi, I was wondering if it's possible to display multiple lines in a message box.. I need the message box to display information that is inputted on a form. Once the user is finished entering information in the form, they click a button. Then the message box with the information the user...

Hello, I'm trying to run a batch file located on a network drive using the shell function in Access 2000. I get the commmand prompt window to appear but in the window it says: "Your Data Access Path - C:\Docume~\User\MyDocu~ - is Invalid Press any key..." Is this error occuring...

Hi, I'm trying to copy modules from one database to another database. The problem i'm having is that i'm getting that nasty "Error accessing file" message when i try and open the modules after copying them. I'm doing the copying using VBA (I need to copy using VBA). I know that in...

Hi, I'm having problems with my forms after I copy them to another database. When I try to open the copied form I get a nasty error "Network connection may be lost". I was wondering if the event procedures in forms are copied when you perform the CopyObject function or the...

Hello All, I have a database (main database) that creates two other databases. The main database has all the tables, querys,forms, and reports. The forms, querys, and reports are copied to database 1, and the tables are copied to database 2. I was wondering how to make link tables in...

Hello All, I have a database (main database) that creates two other databases. The main database has all the tables, querys,forms, and reports. The forms, querys, and reports are copied to database 1, and the tables are copied to database 2. I was wondering how to make link tables in...

Hi all, Here's what I have: recordnum = DCount("*", "MyTable", "[TableField] =" & StartDate ) StartDate is defined earlier in my code. Right now, i'm getting Zero for recordnum when there are 6 records in my table that have [TableField] = StartDate. Is this a...

Hi All, I want to add one day to a date. So if I have date1 = "5/20/2002", I would like a function that adds one day and gets date1 = 5/21/2002. So it's basically date1 = date1 + 1 (but i know this doesn't work - type mismatch). Any help appreciated, NG

Hi All, I have a combo box on form1. The user selects from the combo box. If the combo box doesn't contain the appropriate value, the user hits a button and opens another form (form2). They input the value in this form. The combo box on form1 is linked to that table. So, as the user inputs...

Hello All, I would like to remove all menus when my database opens. I don't even want the file/edit/view/Favorites/Tools/Help menu. I can get rid of all menus except this one. Can anyone help me out? Thanks, NG

Hello All, I'm using the DateDiff function to find the time difference between two dates. Right now I am getting the results in minutes. However, I would like to have the results formatted as follows, Days: Hours: Minutes So if the result (in minutes)is 1265, I would like it to be...

Hello All, I was wondering if it's possible to create a button that on one click opens a form and on the second click it closes the form. If this is possible, does anyone have any idea how to create this button. Thanks, NG

Hello All, I've been away from Access for over a year now and I have forgotten the basics. Here's the scenario, I have a text box that contains the difference of two dates, it's in minutes. On the same form I have another text box that is part of a table. I need to copy the time difference...

My code runs too quick. I need to slow down the process. I have a percent count box that increases in value as records are viewed automatically. Along with the count there is a percent complete bar that suppose to increase as the percent count increases. If I step through the code it will...

I have the following code: Private Sub Dim key as string Dim Lst as control Lst = Me!list1 key = Lst.Column(0) docmd.RunSQL "DELETE * FROM Table WHERE Field = " & key & " End Sub When I run it it says there are no rows to delete, but the key string contains a value...

I have a list box in which a user selects a record and I need that record to be copied to a list box on the same page when a button is pressed. Then, that record has to be deleted from the first list box. And vice versa, the user can select a record in the second list box and move it back to...

I have a listbox with multiple columns. The table for the listbox also has multiple columns. I currently am able to have multiple selections of the table copied to a temp table after clicking a button, the problem is that only the info in column one is copied to the table. I need to copy the...

I was hoping someone could suggest a function to select a number's decimal and all numbers after the decimal. Then cut and copy this to a text box on a form. The number is currently in a text box. ex. Have: text box 1 --> 3.778987665 Need to have: text box 1 --> 3...

I have a multiselection list box. After making multiple selections in the list box I need to copy the selected record(s) to a temp table which I have already set up. I was thinking I would use a button to do the copy when pressed. What would I put in the onclick action for the button to copy...