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  >>   Security Question Have just finished my first database for the elementary school where I teach. We have set the permissions so that the teachers have read and read/execute access, while the other administrators and I have full control. On my menu page, I have a button for "Add Student". Is there a way to have this button disabled if a teacher logs on and enabled for an administrator? Thanks! ... 6 30.09.2006 17:31:02 Access Runtime Startup Messages Hi i have just made my first database using the runtime option, and wish to distribute this to all our office pc's none of which have access. The problem i have got is that when starting the application the user gets three messages warning bout security and such like. is there a way to turn these options off in the runtime version like their is in the full version ?? please emai... 5 30.09.2006 16:30:01 Question about Reports in Access and Excel Is their a way to have a grouped type report in Excel like you could have in Access? Thier also may be multipl purchases and totals for each customer so that I guess would be a one to many and many and many. Is this possible to export an Access report to Excel with theis type of query. I always thought as Excel as a type of flat spreadsheet type application. Example: name XXXXX XXXXXX... 2 30.09.2006 13:54:18 basic question: decimal, single, double when i input 3.1234567890123456789, single data type: 3.123457 double data type: 3.12345678901235 decimal data type: 3 does it mean only single and double data type can show decimal point? thank you! ... 5 30.09.2006 13:27:37 Access question Hopefully this will be easy for some people. I'm trying to write an If statement in VBA for access, however I think I am formatting it wrong. What I am logically trying to do is this: If the first 6 numbers in this given field does not equal 000001 or 000002, then carry out the rest of the function. Currently I have it formatted like this: If IdentificationNumber <> 000001 Or Ident... 2 30.09.2006 06:11:01 How do I align my font what the icon doesnt work The align icons on my toolbars are in active. How do I align my text?... 6 30.09.2006 05:43:40 Access Drops File Extensions on Import I'm importing an excel spreadsheet into an Access table. One of the fields is a filename, formatted as general, e.g.: \\delphi\home\hwlab\SHIPLOG\3806-0002-CM2-02.ship.report.092106 When that field comes into Access, it drops everything to the right of the first ".", so the Access field (data type = text) says: \\delphi\home\hwlab\SHIPLOG\3806-0002-CM2-02.ship. I happens even when ... 2 30.09.2006 01:05:39 P/N-Package-VRRM(V)-Io(A) Conditon-IFSM(A)-VFM(V)-IRM(mA)-Tjmax( C I am trying to determine if Access is the best database builder to build a database that allows a person through pull downs to build a part number based on data inputed into 10 different fields as above. Each field or colume will have many different electronic rateings or numbers/letters. The goal is to have the person start with 1 filed select what best fits his application then conyiu... 2 29.09.2006 23:23:04 Access question Hopefully this will be easy for some people. I'm trying to write an If statement in VBA for access, however I think I am formatting it wrong. What I am logically trying to do is this: If the first 6 numbers in this given field does not equal 000001 or 000002, then carry out the rest of the function. Currently I have it formatted like this: If IdentificationNumber <> 000001 Or Ident... 2 29.09.2006 20:28:02 cm to inches Hello, I was wondering if somewhere in the options of access there is a field where I can change from centimetres to inches (word & excel both have this). thanks!! B... 11 29.09.2006 18:57:01 How do I calculate year and month in two fields in an access quer. I am working in a database where I build profiles, i have general information that I need to turn into more specific information on a report. For example, I have the birthdate of a person and I've pulled that into a query which calculates their age so that I can show that on a report. The issue I am facing now is calculating how much time in years and months that a person has been worki... 7 29.09.2006 17:54:02 Query design grid splits out "or" criteria I am designing a query based on parameters entered from a form. I have entered many parameters such as: [Forms]![FormMainSearchPopup]![apbox] or [Forms]![FormMainSearchPopup]![apbox] is null The query works fine, however, After I run the query and go back to design I now have a field in the grid called [Forms]![FormMainSearchPopup]![apbox] with multiple criteria set to "is null" and my ... 3 29.09.2006 17:33:01 Multiple action queries If I set up several action queries (append or update), is it possible to have one "master" query that calls the other specified action queries and run them in sequence? Thanks -- Return email address is not as DEEP as it appears ... 10 29.09.2006 13:34:01 Listbox source = directory Hi group, I have a listbox containing all the available word documents contained within a directory. At the moment all the word documents names are i a table and the listbox is boud to the table. I would like the table to look up all the word documents in the directory and populate the listbox. This would obviously mean that if a word document was added to the directory then it wou... 5 29.09.2006 13:20:02 How can I add an edit record button Hi, I would like to add an 'edit record' button to my form. Can anyone help getting me started on doing this. I'm pretty new to Access so am not that familiar with it. Do i need to change the data in the table in order for this to work? If so how can i create a button that takes me to the relevant item in the table? Thanks Jamie ... 6 29.09.2006 12:08:54 XP explorer operations from within Access? Is it possible to set up a command button (or anything else) that would do something like open a windows explorer window for the purpose of creating a new directory in which to keep Word documents (and/or scanned documents) related to the files in the Access system I'm working up? If so, is there a way to automatically fill in the folder name with some case file information, liike the ... 3 29.09.2006 11:58:02 where is the back space arrow on outlook ? Just set up microsoft office outlook . Every action, send e mail - look for something- can't find an arrow on tool bar to back space to where I began? AOL, yahoo, etc all have the back space arrow on bar? ... 2 29.09.2006 02:43:49 INVOICE I am trying to generate an invoice from the data in the tables I have setup. Tables: Projects, Customers, Employees, Hours, and Expenses. I created one query for the projects and a sub-form for the hours. I created a new report called Invoice. I dragged the query and the form to the report. The report looks great. I added a field at the bottom of the sub-report to sum the hours work... 3 28.09.2006 23:30:42 Removing lines in word Hi Group, In my application the user has the option of print using letter header paper or non letterheaded paper. If the user selects headed paper I would like to remove the top 7 lines of the word document. How would I do this? ... 4 28.09.2006 21:04:10 where is the "more" link? I can t find it... 2 28.09.2006 20:42:08 where all my datas are being stored I have started using your address templetes in Access. It sounds really good. But I dont know where all my records are stored. How do I modify the old data. thanks Raghavan... 2 28.09.2006 19:27:52 Help with Multiple record - one client Hi, We receive an excel workbook of information from an outside source. Within this table the customer may have several record lines assigned to their customer number. Each line has the customer number, a purchase date, a part number, description and cost. Example: 10222 07/10/2006 carbide burr 3/8 inch $234.00 10222 08/17/2006 widget 1 inch $456.00 1022... 4 28.09.2006 19:24:42 List box changes values for all entries Hiya, I have read similar queries to this but couldn't quite figure out the response! I am setting up a basic database of clients details, and would like to include a list of their current status. I have set up a field to do this and specified the different options for the list. The problem is when I go into the form to select a value for one client, the details change for all clie... 2 28.09.2006 18:01:03 How do i combine columns Access 2003? I have a database that has the street number in one column and part of the street name in two other columns. How can I combine them?... 4 28.09.2006 17:37:02 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... 5 28.09.2006 15:29:15 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  >>