Threads Replies Last Post 153 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Display/Hide subform via command button Is it possible to set up a main form that has a subform, but the subform is not displayed unless someone clicks a button to open it? If so, is it possible to do it so the detail section of the main form essentially expands to accommodate the need for more space when the "display subform" button is pressed (so that there's not a bunch of extra "blank" space in the display of the main ... 4 28.09.2006 13:52:02 Select query generating new field? Hi all, this may or may not be possible. I have a table that contains fields YEM and YED containing integers. YEM contains a nunber in the range 1 through 12 inclusive, representing a month. YED contains a number in the range 1 through 31, representing a day within YEM I want to do a Select query which generates a date, such as DateSerial(2006, YEM, YED) and display this as a new fie... 4 28.09.2006 13:45:48 Module not working I am a new Access user, and am using access 97. I am working on setting up a callout list where the order is determined by overtime hours worked. I set upa query that adds the hours at start of pay period with the hours worked and gets total then sorts it. I then need it to show the updated place in the order. I found a funtion that does that in another post here, but when I put the... 15 28.09.2006 13:03:31 #DELETED error in form Alas, I too am a Newbie! I delete 4 lines of "test" information from my query which left me with "#DELETED" on my form for record 1 through 4. How can I get these "Deleted" errors out of my form? I don't have these errors in my query or table. For future reference, what is the correct way to get the test information deleted. Through the form? -- sssadie :)... 3 28.09.2006 12:21:16 How do you store a single constant in Access? Currently I have a select query that prompts for a value when I run the query. It is a single value that does not vary with any records. How would I go about storing that constant separately within the database, for the query to interrogate when run so that the query does not prompt for it? Periodically the user would want to overwrite that value, which would then be stored in the same... 10 28.09.2006 10:28:39 sql in VBA for ACCESS-- help .. plz hi i have a table LS1018c.that has fields..config, boomlength, opra. i defiened a query that takes input from two text boxs (txt_or and txt_bl)and combo box(combo_config). now i could not get the input referenced to the sql. it is again asking the perameters ..please tell me where i am going wrong.. thanks in advance.......... ASTY Private Sub cmd_capacity_Click() Dim db As DAO.Database... 3 28.09.2006 10:25:07 Form Filter I have created two form filters in Access 2003 and I want to run them from the All Cases Form using a Command Button for each filter , but when I create the command via Apply Form Filter only one is applied . How do you link a command button to differant filters. Best Wishes Bruce ... 1 28.09.2006 07:47:58 MDB or ADP, what's that all about? When I try to navigate the Office Assistant in Access I frequently see two references to "help" on a particular search topic. One link would have "(MDB)" at the end, the ather ("ADP") What's that all about, please? I religiously go down the "(MDB") route, for no reason other than that the databases I create in Access have that extension. Is that the right approach? -- Return ema... 3 28.09.2006 07:18:50 How do i set a GMAIL account to be my main account? question is self-explanatory... 2 28.09.2006 04:14:23 Microsoft online templates How do I view & print report (button already there) from Access contact management online template? I would like to use this template, but it wouldnt be any use to me if I cant view the contacts as a list and then print it out.... 3 28.09.2006 01:47:56 Too Few Parameters Problem w/Query WinXP Home MS Access 2003 I am trying to run a concatenate function in a query and I'm having a hard time. I swiped a module from a member here on the board but I'm having a hard time getting it to work. Whenever I run it, I get "Too Few Parameters. Expected 1." I can't seem to put my finger on what I'm missing. If someone could take a look that would be great. Both the quer... 6 28.09.2006 01:04:02 Query produces unpredicted result Tables ===== T_Clients contains three fields: ID_Clients = autonumber, primary key YEM = integer in range 1 through 12 (representing a month) YED = integer in the range 1 through 31 (representing a day in a month) T_Tasks contains three fields: ID_Tasks = autonumber, primary key ID_Clients = number (related to T_Clients.ID_Clients) PeriodTo = Date Queries ===== ... 2 27.09.2006 23:16:25 labox and drift Hello, I am working on a gantt type of chart, using a textbox, continuos form, and labox text, as well as some vertical lines to demarc hours and half hours. On the far left everything is fine with with the labox text string, but as the bars and spaces moves towards the right, I get what I am calling "drift", whereby a time bar that starts at 10pm looks like 10:10 and goes to 11:10 in... 4 27.09.2006 21:08:51 Error Messages I get these messages 4 times each every time I open Access 2003. How can I correct or delete the problem? 1. "The report name 'Name Tag' you entered is either the property sheet or macro is misspelled or refers to a report that doesn't exist." 2. "The form name 'Names' is misspelled or refers to a form that doesn't exist." I think in both cases, they have been deleted. Also there... 13 27.09.2006 19:07:01 access: module with for/next loop I've created a userform called "user form 1" for now that allows the user to input the number of records they'd like from a query table called "test". (the database will be used for customer mailings.) I need to generate code that: Pulls the numerical value from the userform and moves ( cut and paste) that number of records to a new table or query table. ( In excel you would use a For/Ne... 1 27.09.2006 18:51:02 Copy Title info from Outlook Express address book? I successfully followed the directions to copy my address book in Outlook Express to Office Outlook 2003. However, the information in the Title field did not copy! I use that field as the first line in labels. I deleted the copy and tried a second time with the same result, making sure that duplicates could be created. Any suggestions?... 2 27.09.2006 17:24:25 application.followhyperlink I have a form with a pull down list of names(Name). I set up another box to launch a file Name.doc when clicked. I would like the file associated with the chosen name to launch when double clicked. Here's what I have but it doesn't respond. Private Sub Text194_DblClick(Cancel As Integer) DocLocationAndName = "\\ad\userfiles\public\" & Me.Name & ".doc" Application.FollowHyperlink DocL... 6 27.09.2006 17:12:01 how to set up a simple db for my PTO and sort by committees I'm trying to set up a simple db for my pto - name, address ,email, committee. and then i would like to sory by commitee. for example, all members that signed up for fundraising. How do i do this?... 2 27.09.2006 16:10:41 Unbound Recordsource throught Code I have a form that I set the Recordsource to equal a query that I prepared earlier. Then I bind the controls to the form. I would like to code the section that will unbind the controls and unbind the form i.e. make the form unbound. I can set the forms controls to unbound but I can't make the form unbound without getting the message; "Index or Primary key cannot contain a null valu... 4 27.09.2006 15:49:15 What tables do I need? I am setting up a database to help track assets that we use as demonstration stock. We lend these goods to prospective customers. Whenever one or more of these goods go out to a customer, they are accompanied by a pro-forma invoice. Am I right in thinking that I should set up: a table listing the goods, a table listing customers, a table listing the pro-forma invoices, and a junct... 2 27.09.2006 14:43:03 Auto Number I have imported a old data base into Access 2003 and have a auto-number field that was being used in the old file. It is a membership number and needs to increment by one for each new member. I need to give it a starting number (for instance 8650) and have it go on from there but I have not been able to get it to do that. It always wants to start at 1 and continue from that point. I ... 6 27.09.2006 13:56:25 Create table query syntax Hi all Could someone please give me the narrative/syntax for a simple create table query that has the following effect? T_Clients contains ID_Clients = autonumber, primary key YEM = number, integer in range 1 to 12 incl YED = number, integer in range 1 to 31 T_ClientsROLL1 contains ID_ClientsROLL1 = autonumber, primary key ID_Clients = number RollDateStage1 = date There is a 1-... 4 27.09.2006 13:27:55 What is Office XP, Version 2002 SBE as distributed with a new PC? I have a CD that was distributed by Dell with the purchase of a new PC. I have not been able to obtain updates. Further, I have not found any reference to "Version 2002" on the Update site. What am I missing or doing wrong and/or fail to understand?... 2 27.09.2006 08:52:26 Can't change the path of a linked table I create a new database and import the linked tables, when I want to change the links to the new location it said "THe Microsoft Jet Engine couldn't find the (tblName).Make sure the object exists and that you spell its name and the path correctly. The path of the Old Database is like that P:\MyDatabase\ MyDatabase Back End\My_Database_ be.mdb and I want to change it to P:\NewDatabase\ NewDat... 2 27.09.2006 04:08:01 Help!Wat diff between subform and filter?-New user pls help I am a new user, I wish i can get some answer over here, I think it is easy but i really new and know nothing. 1) Using wizard to create database or VB code ? Which 1 better? and Y? 2) I using wizard to create a form c/w subform as per below Main Form [YearMonth] : 200609 =>[YearMonth] is a field from table period Subform [Transaction] (detail or all fields from table Transaction e... 3 27.09.2006 03:31:02 153 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>