Search results for query: *

Is there a way to change the caption of a query column using VBA?

I need help with a combo box function that I have on a form. I used the combo wizard and created a combo box that looks up a record on my form, based on the value selected in my combo box. What I would like to do is filter the combo box . My database uses the project number as the unique...

I have a combo box that I want to change the back color depending on the selection made. I have the code working but my problem is that when I switch records the color from the previous record remains. Is there a way to reset it to the default color? I'm some what new to all the coding options...

I have a DAO database that has a search built in SQL that creates a query with the search results each time its run. To activate the search you click a command button. The rest of the form has text boxes to display the results. The problem that I'm having is that when I run the search, the...

I have 2 tables that have asset numbers. I want to compare the first table to the secound and get a list of the assets that do not match the second. Does anyone know how I would do this???

Does anyone know how to copy the current Form record data in to a new record. I would also like to clear some of the fields in the new record. This will save the person inputing from having to retype information.

I want to use the "Duplicate record command" to copy information to a new record. I also want to clear a few of the fields when I do so. I have tried this code and it works accept for one problem. It also clears the fields in the original. thanks in advance for any suggestions. Private...

I have a password table with the fields PasswordID AutoNum InsId Text Name Text I'm using this code to password protect a field Private Sub Detail_Click() Dim strpword As String Dim iResponse As Integer strpword = InputBox("Enter password") If strpword =...

I have been trying to use the NPV Function (net present value) in a form with no luck. Ideally I wanted to use a text box to calculate the value based on input I.e. NPV(Discountrate,year1,year2,year3...etc)but judging from what MS had on their site I don’t know if it will be possible. I tried...

I used this code to highlight labels for check boxes on a form now I would like to do the same for my report, but I keep getting an error "You have an expression that has no Value" I know I'm probably not referencing the report controls correctly. Currently I'm using the on open event. Any...

Hi, I need help writing code to highlight a label when a checkbox is checked. I want o be able to call this procedure so I don't have to code it a 100 times. Here’s what I have so far but I know its wrong. Any help will be greatly appreciated. Thanks Option Compare Database Option Explicit...

I have a check box that turns on and off the Visible format of a memo box. I want to be able to automatically uncheck the check box if no information is input in to the memo field. This is what I tried so far with no luck any suggestions would be greatly appreciated (I have tried it with...

Hi all, I need help passing the Email address in to Lotus Notes using DoCmd.SendObject& Snapview. All that seems to pass is the subject line. Any help will be great. Thanks. Here is my code. Dim strTo As String Dim strCC As String Dim strBcc As String Dim strSub As String Dim strBody As String...

I'm not sure if this can be done, but here it goes. I would like to display a week of attendance information in a report format that displays it like a spreadsheet. This will be a new database so I can construct it however I need to. I’m not sure how I would write the code to pull the...

Hi all, I'm just a newbe so forgive my ignorance. Does anyone know how I would code this to use in a public module (works fine in privet call)? I keep getting an error that I have misused a keyword when I use it in the public call. Public Sub Cmd_Edit() Dim iResponse As Integer iResponse =...

Does anyone know how I could sort this type of data on the first 4 digits; this is a text field. I would like to use SQL to do it. Thanks for all help. 1170 60 1745/1160/870/570 850 1730 3600 3600 3 3500 5