Threads Replies Last Post 901 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  >>   Conditional Formating Expression Hello, I am trying to write an expression for a conditional format. In a form for data entry, users enter a "school name". This name comes from a drop down menu, and the items in this drop down menu come from a table callled "school list." In school list, there is a column called "Special School?" with a "Yes" or a "No" in it. If it is a "Speical School?" (so, yes), I would like the "... 5 20.09.2006 16:07:02 Logging In I currently have a database in Access 2003 with user permissions and passwords. When the relevant user logs in they go to the form and assign themselves to a job. However, at the moment it would be possible for them to sign in and assign a job to another worker. Is it possible to create a piece of security where a user logs in and can only assign him/her self from the drop down list wi... 3 20.09.2006 16:04:02 Access 97 to 2002 conversion bug I need help. In my form code running in Access97 the following code works great. ' '--- use SQL search to fill TmpFxtrData ' 'SQL search criteria: 'SELECT * FROM tblFixtureData 'WHERE ((LocaCode) = strSrchCode)AND ((ElmntRmvd) = nothing) 'ORDER BY FxtrNum, ElmntPos ' 'build string version strText01 = "SELECT * FROM tblFixtureData WHERE " strText02 = "(((tblFixtureData!LocaCode)=" & ... 4 20.09.2006 15:43:02 SELECTING RECORDS FOR A REPORT My question results from being a very basic user of Access I have a database of purchase orders which I would like to create reports based on their respective job numbers, ie. produce a report with only the po's for one job number appearing. Can anyone advise how to accomplish this please? ... 2 20.09.2006 15:41:02 Automatically generate data Guys, One of my users has a database which has a Field called Visit date which is of course set as Date/Time. She wants to have another field called Next visit which will automatically put a date in. This date should be the visit date plus 7 days. So the idea is that once she enters the visit date, a date 7 days later is automatically placed in the next visit field. Is this possib... 4 20.09.2006 15:38:04 Don't know how to add a member to a report object. I inherited the maintenance of an Access 97 report. The VBA that executes OnOpen of the report clears all records from a certain table, computes a bunch of values, and writes them to the table. The data displayed in the report is from this table. I added a new field to the table, then added a line of code that writes a value to a new element of the table. When I did this, I was able to ... 2 20.09.2006 15:28:58 Refresh network connection / link? When I log into my database in the mornings, using a dedicated link for my user level security, it usually fails to open the database. I receive an error message something along the lines of 'unable to locate requested file'. My database is located on a network drive - all I do is open the file which contains my database and it all works again fine. It's not a huge problem but I'm about ... 3 20.09.2006 15:27:29 using groups for data entry I have a database for contact management, but I want to filter/group for the data entry, which I will try my best to explain here what I need to do. When entering a company, we always report on our data by members or non-members (we are a trade assocaition), and the members are then split down into the membership category (relates to the company activity) i.e. property developer, lawy... 3 20.09.2006 14:38:53 Command Button hi ! I want to change the back color of the command button. How can i do it ? Pls. help... 3 20.09.2006 14:34:58 Query Hi, I have a table with columns Table 1 Columns: Policy; Total Account Value; Bond; Stock; Money Market Table 2 Columns: FundAllocation;Bond; Stock; Money Market I want to create Table 3: Policy; Total Account Value; Bond; Stock; Money Market;FundAllocation Fund Allocation is a certain %, there are 10 types of fund allocation with the data = 1-10, so I just want to add the corr... 2 20.09.2006 14:18:31 Linking Access with ODBC Hello experts, I have a question regarding linking a table in Access. I go to FILE; GET EXTERNAL DATA; LINK TABLES. I then choose ODBC Databases and link my chosen table. During the process I'm asked to Select a Unique Record Identifier (you can select up to 10). When I select only one unique identifier, my data appears to duplicate on particular rows and other data isn't select at... 3 20.09.2006 13:11:26 Messing With Dates I had a list of date calculations that was about two pages long, put out by Microsoft. It would allow you to calculate the date of the end of the next quarter, for example. The lisgts I find on the knowledge baqse are much shorter and simpler. Can anyone tell me where to find this list? ... 2 20.09.2006 12:13:47 Implementing hierarchy in Access tables I am developing an Access DBMS to manage local history information, artifacts, photos, etc. A crucial part of this is the people referred to AND the realtionships among them. Within the tblPerson one person could be a spouse of one or more persons, each person could be the child of a couple, a couple could have one or more children. I am trying to show how the tblPerson relates to itself... 14 20.09.2006 11:25:41 Toggle checkboxes Hello, Not sure if this is possible or even a good idea, but here it is: I have a yes/no field that I would like to control 2 check boxes [ok, I suppose it would be more accurate to say that I want the check boxes to toggle the value in the field]. When I check box 1, the field needs to be "true", and when I check box 2, it needs to be false. Thanks.... 3 20.09.2006 10:48:01 Click then go to clicked record List Box subform 200601 content of 200601, 200602, 200603.....etc data 200602 200603 * 200601 = 1st record, 200602=2nd record ...... When i click record at bottom then the subform will list out then data, but if i direct click on the list box(but record at below still showing 1 record, but subform change the data base on which value i click) then i move to... 1 20.09.2006 10:11:02 update fields Hi, I have a table with 2006 model numbers and prices. I want to have Access (2003) update the 2006 price field with the new 2007 prices by matching the model numbers that are coming from a new table with 2007 prices. Also, can Access tell me if there are any new model numbers in the 2007 table that were not in the 2006 table? Any help would be greatly appreciated! Thank you and regard... 2 20.09.2006 09:58:14 parent child relationships Hi all, Does Access (2003) have an "auto report" that will reveal any and all "parent child" relationships and print the relationships for me? Also, in reports... is there a way to find any "missing" headers and if any fields are "null" can the report list the locations of the "null" fields for me? Any and all help is greatly appreciated... Thanks and regards, Candice... 1 20.09.2006 09:37:01 comparing memofields I have 2 memo fields in table1.field1 and table2.field2. I need to compare them, and get the rows where the fields arent equal. How can one accomplish this? Thanks advance of Francis ... 8 20.09.2006 08:33:54 GetOpenFileName: lpstrFile vs lpstrFileTitle?? I've got some code that I cobbled together and which has been working for a few years - but it only handles single file selections. Now I'm trying to make it handle multiple file selections. I can get the CommonFile dialog to accept multiple selections, but as soon as I specify too long a file list, it dies. Let's assume that the user will never, ever select file titles whose length sum... 4 20.09.2006 08:20:07 Exiting Memo Fields Very beginning question from a rank beginner. When entering data in a memo field, how do I exit or leave the field in Access 2k using XP? Thanks in advance, Phil ... 3 20.09.2006 07:02:09 OLE Objects Hi eveybody, Hope some one can help me, I know this is probably a dumb question but here goes, I want to insert a banner and watermark on my reports I have save both pictures as OLE objects in a seperate table, the reports are generated from a query in total I have 36 reports in two sets of 18. On each report I want a company heading as a banner and watermark. How do I do this, I've ... 5 20.09.2006 06:31:02 crash on find and replace I am using an access database for file management; when i use the "find" and "replace" function the database crashes (and closes). The information is updated but it is very disconcerting.... 2 20.09.2006 06:16:07 Did I make everyone mad? Hey guys - what's wrong with my questions. Nobody knows how? Nobody responded.... 6 20.09.2006 06:10:53 Access Training Suggestion Hey Ya'll I'm looking for suggestions on training/courses. I have been using Access for several years and have developed and support several well-used applications. I split the databases and use VBA but I would like to learn more about using SQLServer/ADP with Access. Has anyone taken any training or suggest where I might go. Thanks in advance.... 4 20.09.2006 05:56:57 AppActivate will not retain focus All, A co-worker is trying the following... any advise... Thanks I am trying to take a screen print and pasting it into MS Paint however, Paint won’t retain focus so Sendkeys sends the key strokes directly to Access and I get a blank picture On Error GoTo BadStart keybd_event VK_MENU, 0, 0, 0 keybd_event VK_SNAPSHOT, 0, 0, 0 keybd_event VK_SNAPSHOT, 0, ... 2 20.09.2006 05:48:47 901 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  >>