Search results

Thanks Rob! This worked great. I appreciate the help!

There is probably a very easy way to solve this problem, but unfortunately I can't figure it out. Hoping someone can help.........please! I have a listing database which tracks all of our properties. I need to start tracking what services have been done on these properties, so I added a new...

Just wanted to say thanks for the help. I solved the problem. I decided to use a DLookup on the before update of the name field. Then if it finds a duplicate it will open the form.

Thanks bjackson, but that didn't work. It still gives me that Type mismatch error. Any other ideas?

I converted my tables to SQL and am now having issues with a macro that gets run when a new record is added to my clients table. The way I have it set up is when a new client name is added on the afterupdate property of this text field I have a macro running that searches for duplicates. It...

Thanks, KKilfoil. I am not that familiar with VBA, but I'm willing to give it a shot. Do you (or anyone else) know where I could get an example of code to work with? Thanks a lot!

I'm really hoping that someone could give me some pointers on how to do this. I have set up a form where the end user enters a begin date and end date, clicks on a command button and prints 4 different reports for a neighborhood one right after the other. This works great. Now, the end...

Thanks, Richie. That worked great!!

I need to develop a report that sums commissions by office based on account number. I've created a field that assigns a "DeptIDMarker" of either "A" or "B". Now what I can't figure out is how to Sum(Commission) where DeptIDMarker = A and then another field to Sum(Commission)where...

I have developed a report that has a group header & footer on. I have set the group footer "Force new Page" property to After Section. This works great except for it prints a blank page at the end of the report with just the report header on it. Does anyone know of any code I can use to get...

Thanks, Jack. I am doing as you suggested. I added a retired (yes/no) field. If it is checked I have it coded to run the append query which copies the data into the table Retired Computers. This is the query where I used the criteria =[Forms]![frmRetiredComputers]![AssetNumber] My question...

I developed a database that keeps track of all assets in our technology department. We are in the process of "retiring" some assets, example, computers. Thus I have created two tables, tblComputers and tblRetiredComputers. I have added a command button to my Computer form that users can click...

Thanks Pat. Your help is much appreciated.

I'm hoping this is something really easy that I'm forgetting, but when I add a new record in my form and click on the preview form button (to preview my report)none of the fields are showing up. I have the button based on a macro, so I went back and put in a Save command to save the form before...

Please help! I am encountering many problems populating a combo box. I need the combo box to be a list of ip addresses based on an office id. Here's the catch. I need the combo box choices to be restricted by whether our network admin. has used an ip or not. So, I'm thinking I could...

I have created a form where agents go in and select a neighborhood from a combo box. (row source-query) They then procede to enter information on these neighborhoods into 4 subforms that I have bound w/ the record id number (autonumber). My problem is that instead of going to a new record...

I don't know if you've solved this problem yet or not, but I've used this code in one of the applications I developed and it seems to be working fine. Try it and see if it works. Private Sub DeptId#_AfterUpdate() 'This will update your Dept. Name field based on the value selected in the...

Is there a way to enable the up and down arrow keys to make them scroll through data in a continuous form? They work in datasheet view, but not in continuous. I would appreciate any help on this. Thanks.