Search results

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

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

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

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

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

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

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.