Search results for query: *

I have a very simple database. Client table connects one-to-many to attendee table and Attendee table has a one-to-many relationship with Survey table. Client is the main form (single form) with Attendee as the subform (continuous form). I'd like to put a button on the detail row so when you...

I have one table, City, that contains an autonumber field called AddressID. The other fields in that table are text and are City, Township, County, Zip and State. I have 2 combo boxes I'd like to cascade. The first combo box is cboZip, which is text. The info for it comes from the City table...

Hi All! I have a Horizontal Tab Navigation Form. I can get the main form, Client, to open to a new record when the database is opened with no problem. Client has a tabbed subform, Programs, which is setup as a continuous form. Whenever they click on the Programs tab, I'd like it to open to a...

Hi All! I have the following code in the on double click event: Private Sub cboPhyLocation_DblClick(Cancel As Integer) Dim frm As Form, rst As Recordset DoCmd.OpenForm "Contact Info" DoEvents Set frm = Forms![Contact Info] Set rst = frm.RecordsetClone If rst.BOF Then MsgBox "No Records!" Else...

I have 3 tabbed forms. First tab is Client which is the main form. Second tab is Program which is a subform of Cient. Third tab is Changes which is also a subform of Client. I choose a client and can easily click any tab and all the data is filtered for that particular client. Change the client...

I'd like to use the new Horizontal Tabs 2 level navigation form for a new database but am having problems getting it to work. And maybe it won't work the way I'd like. I have a table, ClientInfo, with a primary key of ClientID. A Program table with ClientID as the foreign key and ProgramID as...

I need the Premium add-on for terminal services to support remote desktop. I realize that I'll need one set of CALS for the 2011 Standard and another set of licenses for the Premium Add-On. They will be residing on the same server. Does anyone know if the CALS for Premium Add-On cover Remote...

I need the add-on for terminal services to support remote desktop. I realize that I'll need one set of CALS for the 2011 Standard and another set of licenses for the Premium Add-On. They will be residing on the same server. Does anyone know if the CALS for Premium Add-On cover Remote Desktop...

I have a query that contains a calculated field that determines the age of a client. Let's say Johnny's birthday is July 3, 2004 and I am running a report from July 1, 2009 through July 31, 2009. Johnny shows up as 5 years old. But....for the first two days of July he was 4 years old! I need to...

This should be simple but no matter what I try it's just not working for me. I have a main form called Client that has two subforms. One subform is called Family Members and the other subform is Training. The main form contains a primary key. Each of the subforms has a foreign key. I am using...

I'm not even sure if this is possible...but I've been working on it all day and need assistance. I have a query that sums the miles by program. Example: Jane Doe Program Miles ABC 232 MATX 102 GHI 5 JKL 30 I can easily get my report to show the maximum value out of the four...

We have SBS 2003 running on our current server. We are ordering a new server that will be replacing our current server. Can SBS 2003 and the user licenses be installed on the new server? Do I need to purchase SBS 2003 and or new client licenses?

Hi! I've been working on this problem for the last week and while I can get close...it's never close enough. I have a report with a subreport. The report is rptMailingDateAndSum based on the query qryMailingDateAndSum. It's subreport is rsubMailingDateAndSum based on the query...

Hi! :) I have a dialog form that contains a couple of list boxes. All was working well till I clicked on an item in the listbox that contains an apostrophe. Example: Appeal works Appeal's won't work. I get an error message and the report fails to generate. The listbox is an unbound control and...

Morning :) I just set up a Windows x64 system...after getting around everything else that I new would come up on a 64 bit system I ran into an issue with office 2003 and wondered if anyone else had a similar issue. It installed smoothly. I updated it and everything else on the system. Runs great...

Hi All! :) I have a crosstab query that I can click on and export to excel and it works just great. Thing is...I go behind the form interface to do this. I'd like to put a link on the report menu form so that other users can click on this link, the same as when they run a report, and it will...

Hey All! Any tips will be appreciated. I have an office without a server that has cable internet connectivity. The cable modem is connected to a wireless Linksys router. Basic setup. Works fine. The state put in a Cisco router. We will connect to a program through this router and it is...

I have a form where the user enters the starttime and the endtime and then a calculated control on the form figures the difference between the two fields on the form using this formula =DateDiff("n",[startTime],[endTime])/60. The data entry person enters the time in quarter hour increments such...

I'm sure it's something simple that I am just missing. The following line is erroring on Program Admission Date Function YearMonthDate([Program Admission Date] As Date, [Date Discharged], As Date) As String What am I missing in the syntax.

Hi, I'm using the following function and don't exactly understand why it isn't working. I do know that days are a pain to count. Example: 9/27/2004 to 1/21/2005 should be 3 months and 25 days but it comes up 3 months and 26 days. Yet other dates come up right...sucn as 11/4/2004 to 1/12/2005...