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  >>   Adding a new record in code Seems like this should be really basic, but I'm having trouble. I want to add a new record through code, and I've tried the following without success (the strings "A1205" and "Test" are for testing purposes -- the strings will actually be derived in the code): DoCmd.OpenTable "XNumbers", , acAdd Tables.XNumbers.XProjectNumber = "X1205" Tables.XNumbers.Description = "Test" or DoCm... 3 26.09.2006 21:49:40 Multiple Locations Good morning MS Community, I have a table which lists part numbers in the first field and the bin locations in the 2nd field. Since a part may have more than one bin locations (up to 5 or 6) , the table looks like this: PART# BIN A1 123 A1 456 A2 789 B1 etc.... I'd like to get the information organized into a table like this: PART# BIN#1... 5 26.09.2006 20:32:09 help!... urgent and i'm new on this area i need help and its urgent... i have created a table with fields: ItemNo, ItemName, IncomingStocks and also DateReceived. The IncomingStocks and DateReceived are volatile. it is expected to change several times during the life of a record I have tried the simple append query but it keep on copying the whole records instead of the 'ONE' record that i change.. What code do i ne... 4 26.09.2006 20:32:01 Updating a text box from a value in another text box (underlying q Hopefully someone out there can help, There is probably a simple way of doing this but I am at a loss (I wouldn't consider myself an expert in access) Anyway, here is what I'm trying to do. I am currently using a form to update a table, One of the fields is for a job number. An additional text box on the same form is for the job name. What I am trying to do is have the job name au... 2 26.09.2006 18:03:02 #Error in memo field I keep having strange occurrances of a #Error in a Memo Field in two forms I've created. It just appears out of no where, seemingly, and when I try to erase the #Error out of the field, Access tells me that 'another user' has the file open as well. I'm not on a network, the database is only on my computer!! When I try to even look at the record in its corresponding table, it gives me tha... 3 26.09.2006 15:30:02 how to add alphabetical tabs on a database my boss asked me to organise my new database with alphabetical index buttons at the top of forms so that he can quickly go to names beginning with a particular letter... I've been searching high and low but can't find any instructions anywhere on how to do this, is this possible? ... 4 26.09.2006 15:07:01 page banner not publishing I can see all my page banners in my local site, but on my remnote site the banners are missing. What did I do wrong? I would like my banners to publish because it adss colr and interest to my pages.... 2 26.09.2006 14:39:15 edit record Hi, I would like to add an 'edit record' button to my form. Can anyone help getting me started on doing this. 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 item in the table? Thanks Jamie... 2 26.09.2006 13:24:34 how to add to field from previous record if i want to update a value from a previous record by adding to it how would i do that. If the cumulative value in the first record shows 100 kilometres and the next record asks trip distance and i input 25 kilometres i want the cumulative distance to update. is this possible. i've searched high and low and i can't work out if this is possible. thank you to anybody who can be of assista... 5 26.09.2006 02:43:13 ovr insert mode While typing in word 2003 the overwrite function comes on at odd times, even after I disable it. It also come on outside of Word documents, such as when I'm typing e-mail or writing in my blog.... 3 26.09.2006 02:25:50 Increment number I have a database, that has an autonumber assigned, as is required by Access. However, I want a field that says record Number. I have manually typed the number to match the autonumber generated by Access. I sometimes filter the form's output by another checked field, and the record numbers get scrambled. How can I keep the record number matched with the autonumber field, after using a fi... 3 26.09.2006 01:41:42 Design tables and Relationships Hallo, I have a very basic question. I find it very hard to define my relationships and tables. I already know some things but I sometimes miss in the beginning. So therefore. I want to make an acces file to make my day schedule for a teacher. I want to make it possible to enter a date, and insert a course for every lesson hour. something like this: date = .... 9.00 -10.00 / (... 2 25.09.2006 19:05:01 Form directory needed. Does Access2003 keep a directory of forms and other objects that can be referred to easily. Like a comboBox. Frank ... 6 25.09.2006 17:54:45 Number to Currency Hi, I had set field properties in a query to currency, but after Make-table the value in table doesn't show in currency, in table Data type show Number...!! PLEASE HELP...!! new uses... 3 25.09.2006 17:05:23 Subform or not to Subform Hi people, I created a form where data is entered by the user - about a customer. The form has a lot of information and it takes up the whole page. I then created a subform and linked the information I needed and it looks good - or should I say it looks correct. The problem is when I print or when i do a print preview - I KNOW FORMS ARE NOT MADE FOR PRINTING - but in this case I need... 7 25.09.2006 16:39:20 Count I have a database that has a field "Work orders received" in date format. I would like to generate a list of count of work orders received each day ie. 22 Jan 2006 has 12 workorders 23 Jan 2006 has 10 workorders etc. Can I use the count function to do this or do I need to do in VBA ?? ... 4 25.09.2006 16:27:10 File Format - 2000 or 2003? We run Office 2003 but by default new databases are created in 2000 file format. The advantage of 2000 file format is obvious to me (backward compatibility). Of course I could be wrong even on that. What I do not know is what advantages there are in adopting the 2003 file format, assuming that backward compatibility is not an issue. Could someone help me on that, or provide a link? ... 2 25.09.2006 14:59:03 Conserving values in Sub & SubSub forms. I understand that with a Form with sub & sub/sub forms the underlying tables are updated when the cursor leaves on subform and enters another, and in effect the entries are lost to the operator. I need to use the same invoice date for the "TxnDate" in the "ProductTxns" subsub form as I use for the "SuppTxns" on the main form, and I have solved this in the following tedious fashi... 2 25.09.2006 00:07:20 How do I use the IIF expression I am trying to use the iif statement to have it either display/print or if nothing is in the field skip that field. The field is a text field The way it used to be done is: if [field] <> "" then display [field] else skip endif Old Dbase language. In the Access help screen it shows =IIF(IsNull([fieldname]), "", "I'm Here: " [fieldname]) It doesn't seem to work when dis... 6 24.09.2006 20:43:21 access 2003 how do i design an access database table for compiling all the laws to help prepare me for taking a bar examination?... 4 24.09.2006 03:53:58 start up options After using the start up wizard option I specified a form to open when I opened Access. When I open it, the form I specified opens as expected but it is not in the maximized view which is necessary due to size of the fields on the form. I can't figure out how to get it maximized automatically. Any ideas what I'm missing?... 6 24.09.2006 03:48:09 Best practise for Dlookup hitting a null? I was surprised to find that DLookup returns an error if the data being looked up is null. What does one do about this - what if you want to find out if the data is null? How do you prevent an error? ... 2 24.09.2006 00:41:15 Access hidden objects ?? Hi group, Access 2000 win xppro I'm not sure if this is the correct group but here goes anyway. I have a small application that I use in my business. I have been using it without problems for about 3 years. I have the full version of access developer xp on my box and I have the runtime version running on two other boxes. I have the app set to compact on close on all boxes. Rece... 2 23.09.2006 21:24:05 junk characters in query result when i use a kind of large (150 characters or more) text field as the main sort criteron in a query i get a single japanese or other unexpected character in the text field instead of my text. anybody else seen this and know what to do about? tia, mcnewsxp ... 9 23.09.2006 17:49:09 Simple but profound Hi, I have a question which cracks my head. Assume I have a table with a field with the name "Date" and in fact it is a date field. Usually, user will fill the date fill with {[month][day][year]}. However, I want to make it as {[day][month][year]}. Usually to western date style, if I enter 8 2 06 to a field, it will changes to 2-Aug-06 for medium date. Example that I needed: ... 8 23.09.2006 16:28:38 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  >>