Threads Replies Last Post 396 Pages: <<  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  31  32  >>   Generate hyperlink based on number entered on form I am currently creating a database. What im having problems with is I have a field that the user will enter a number of a previously scanned document that is saved on our network share drive (G Drive) when i loose focus I would like to create the hyperlink in the second field. Now for the problem. I cannot create the correct hyperlink. I am currently generating a hyperlink to a fi... 1 18.09.2006 17:07:59 Apply Filter to Datasheet Hi I'm trying to figure out how to apply a filter to a Yes/No checkbox in a datasheet so that the user could click it on to apply the filter and click it off to remove the filter. The datasheet doesn't have a header for me to put this control. So any ideas on how to do it? Thanks..... 7 18.09.2006 17:05:03 Switchboard Menu Title Revisited Hi, there was a thread started by "Giberish" back on June 16, 2006 titled "Switchboard Menu Title". It was answered by Karl Dewey that same day. Can someone clarify Karl's answer, meanining, how specifically is this done? Do I modify the Switchboard Items table by adding a "menu column"? Do I delete a value in the Command column? Thanks in advance for the help. ... 15 18.09.2006 16:44:46 Showing certain record only Hi everybody, I have been trying to work out the easiest way to display certain records only. In my database I have a toggle button that once pressed indicates the record/project has being invoiced. Once a project has being invoiced I would like it to hide itself from selection when navigating through the database. Easy enough! I made a query and it works fine but what if I wanted a toggl... 2 18.09.2006 16:31:33 auto number won't increase I have a command button in a form that auto fills in a reference number for each new entry. It was working properly until recently but now keeps issuing a duplicate error message - it doesn't increase the number by 1 anymore - and since this is a database that I took over I'm not sure what may have changed. An example of a number is 2239-06-112 ( the 06 being the year, the last 3 digits bein... 3 18.09.2006 15:08:23 Check box update I currently have a list of questions within a form and one question is related to the previous one. Should the answer to the previous question be No then I want the next question to be accessible. Should it be yes then I would like the question box to be greyed out and locked. How would I go about this? Many Thanks, Matt... 13 18.09.2006 14:59:11 copy a database I copy a database with the definitions only checked but allways copy all the data.What could be the problem?. Somebody have any idea why this happening and how to fix it? thank you ... 4 18.09.2006 14:47:24 Need more than 1 user accessing tables I lost the steps for which you let more than 1 user to access the database. I know I have to split the database and also make it a MDE file but not sure what to do first. After that what do I have to place on each users comp. The backend will be stored on the network and the front end on the users drive. Correct??? Also how do I have the user just click on the form without opening ACCESS and ... 6 18.09.2006 14:27:47 Hyperlink in form does not work Hello, I am using a Hyperlink-Label in a form. I Set the .HyperlinkAdress to something like http://localhost/Homepage/myFile.xml When I click the Hyperlink in the form, I get "Un unexpected error has occured." When I open the same hyperlink in the MS-Explorer, it works! When I use directly the path on the disk (Z:\MyDirectory\myFile.xml) in the Hyperlink in the MSAccess-Form, it works! ... 1 18.09.2006 13:58:00 Lookup problems I have set up a lookup using the combo box wizard in Access 2003. Everything works just fine for the first few times, I can start entering new record data and the type ahead or whatever you call it starts helping me fill out the information. I can also use the drop down arrow and pick a name from the list, but with thousands of names, this a tough way to go. The problem is that after ... 10 18.09.2006 13:47:02 Cant add any more controls to my form I have a form with many (a lot!!) controls. Now I have apparently hit the limit and I cant add any more controls. Even after deleting some old controls I cant add new ones. How do "compact" my form so that I can add new controls? I tried renaming - as suggested by Access when displaying the message about not allowing me to add a control - but without success. -- Diane... 5 18.09.2006 13:32:02 Button images Hi i have just upgraded to Access 2003, i notice that 2003 has new command buttons and images that look great., when i go into any of my previous databases to upgrade the old buttons it appears that they dont show the new buttons can anyone help me -- fatKemp... 5 18.09.2006 13:17:01 Multiple check box fill in using a toggle button Hi, My question is pretty simple but I cant seem to get the code right :(. I have 5 checkboxes that have 5 separate control sources on a table called ProjectDetails. chkMach chkPrep chkBoard chkLay chkAssemble I also have a toggle button (tglPanelsBuilt) that is the table Project Details. At the moment I can check the different boxes which is cool but once you press the toggle but... 6 18.09.2006 13:13:02 IIF Statements /Server 2003 Our server was updated to a Windows Sever 2003 Since then, all the forms designed in Access containing an IIF stament in some textboxes, began to have a blink every time those textboxes get the focus. The problem was fixed putting the IIF in the Open event of the form. Why? ... 1 18.09.2006 12:56:02 popup property can't be changed at run-time? I have a form that needs to be displayed as a sizable, non-modal form. at various times i also need to call this form up as a non-sizable, modal, popup form. however, i can't seem to change the 'popup' property of the form at run-time. how then can i call the form in these two different ways? Thanks! ... 7 18.09.2006 12:50:01 Date & Time Format in Ms Access Queries Hi, Previously I asked for help on the below request. I got reply from someone which I really appreciate, unfortunately it seems not working. Can anyone verify that funtion and could tell me exactly how i gonna use it. Thank you for the support. This is my previous request: ------------------------------------------------------------ I am a beginner to MSAccess. Recently I imported a hu... 2 18.09.2006 12:11:48 Display data of a listbox in a textbox Hi how could i display the current data ( for example a number '19.4546' ) of a listbox in a textbox the number 19.5 on the same form. I'm doing that because in ms access 97 listboxes do not have decimal places. ... 2 18.09.2006 12:10:10 Datasheet View position detection Access 2003: In a form displaying a group of records in datasheet view there is a need to track the location of the cursor relative to the first displayed record. It it possible to detect the location without having to keep constant tract of the relative position of all records and using the bookmark to move the cursor to the correct location. Thanks in advance for your sug... 5 18.09.2006 11:19:01 Change in query Hi: Can any one please help me in the query. In where clause i want to check if main form is tbl_PPVResearch then it match the condition. If main form is tbl_PPVResearch_edit then it match the condition. Problem is i have two forms. One for data entry and the other form editing. So only thing i need in here when the main form is tbl_PPVResearch this query is ok but when the main form is tbl_P... 1 18.09.2006 10:41:40 Rick B? Duane H? Someone heeeeelp please I posted a q a few days ago (this group, titled "Mainform / subform / popup form") Sorry to ask again, but i reeeeaaallly need some help, and I understand the way you two (and a few others) really explain things, and I haven't gotten any takers yet. Thanks!... 2 18.09.2006 07:30:01 Passing a number from a combo box to a text box in another form I'm new, learning, and have hit a snag. Thanks for your help. All I want to do is to pick a number from a combo box and send it to a text box in a different form. FrmSource is unbound. It has a combo box, cboNumber, that lists choices from tblNumber. FrmDestination is unbound and has text box - txtNumber. I want to click on a number in cboNumber and have FrmDestination open and tha... 3 18.09.2006 04:08:29 Autonumber advancing when opening form I hope I can explain this. I have a form that has fields updated using a combo box. On the form, I have ID as an autonumber. When I click to create a new record, blank form opens at it should, but the ID has already advanced. I want it to stay (NEW) until I start entering data. Unless I press ESC before exiting the form, the blank record will be saved. When a new blank form is o... 3 18.09.2006 01:32:01 Access with Adobe forms Is there a way to use an Adobe form as the form and have the information entered into the form populate the Access table?... 2 17.09.2006 20:23:22 Dropdown list with subform values Hi. I have a subform «B» (as a datasheet) in a main form «A» (linked by «Obra_ID». In this subform, users can enter the values «1», «2», etc., in the field «Order.no» I have a procedure that exports information from the mainform «A» to Word, including the «Order.no» filled in the subform «B». I created another form «C» that appears during the export procedure that ... 1 17.09.2006 19:43:02 Tab does not display all info I have a subform, Order Details. This subform has 8 fields. When the form opens, 5 of the fields are visible. When I tab from to field 6, the cursor moves to that field, but the screen does not. I can enter information into that field -- but cannot see entry until tabbing to the 7th field. Then the screen shifts to the left and I can see 6, 7 and 8 fields. The only other way is to ... 4 17.09.2006 19:17:08 396 Pages: <<  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  31  32  >>