Search results

just to double confirm with u.. this would not cause any loss of data right?

hey i tried to insert a new value into the table using the append query. However the same problem continues to exist :(

hey guys thks for ur replies. What do u mean by compacting database with table? The table currently has alot of records and I have to ensure that none of the data is being lost!

Hello everyone. I have a table called payee table. It has the following fields: payeeID payeeName payeeAddress Postal Code accountNo type The thing is I have created a form such that it allows the user to add a record into this table. PayeeID is actually autonumber and primary key for this...

hey thanks for ur help guys. I tried putting in the with block and it works now. However i have another problem. I got another error msg which is "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship...

Hey the error is still there. when i try to run it, it says compile error " invalid or unqualified ref". It highlights this ![PayeeName] . The thing is my table has the following columns : PayeeID,AccountNo, PayeeName, Payeeadd, type of payee. the payeeid column is an autonumber. I have...

here is what i have managed to come up with Private Sub Back_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("Info of payee", dbOpenDynaset) 'Me.PayeeID = " " rs.AddNew ![PayeeName] = Me.PayeeName ![PayeeAddress] = Me.PayeeAddress...

Hello Everyone! I have an form. The function of this form is that when the user clicks on the save button after entering some data, it should be able to go and store into the table. Does anyone have any idea how I can insert new record into a table through vba coding? Thanks for any help :)

ooohh thanks thanks for ur help soo much! Really appreciate it! :)

hey works perfectly fine! Thanks alot. But may I ask u y dun we need to put the "'" cos in my previous ones i wrote that. Thats y i followed the same thing. Sorry I m still kindof new n trying to get used to all this.

Hey the problem still exists. This is rather weird. I think I have tried almost everything. I think I will just try to set the condition using query. Thanks so much for ur help :D

Hey thanks for ur help . will try this :D thks!

hey i tried it but error still persists. I still get type mismatch error!

Hello Everyone. I am having a small problem. I want to open a second form from the first form based on a criteria. stLinkCriteria = "[PayeeName]=" & "'" & Me![PayeeName] & "'" And "[PayeeID]=" & Me![PayeeID] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria initally when I just set...

I am just pasting my final code here in case someone else wants to use it :) Private Sub Command4_Click() 'Declare you variables Dim dbs As Database Dim rst As DAO.Recordset Dim Counter As Integer ' set up a updateable recordset of your table Set dbs = CurrentDb Set rst =...

oooo thanks! it works perfectly fine! Thank u very much :D

I have a code as follows that I have put behind a button: Private Sub Command4_Click() 'Declare you variables Dim dbs As Database Dim rst As DAO.Recordset Dim Counter As Integer ' set up a updateable recordset of your table Set dbs = CurrentDb Set rst = dbs.OpenRecordset(cus, dbOpenDynaset) '...

hey thanks for ur reply. U mean that I create a new table where the manager will be a primary key and in the existing table the manager will be a foreign key. So I can link it up using relationship. Therefore this will be easy for me to just locate the record in the new table and change. Am I on...

Hello. My problem is that I have table containing products and the person who is managing the product and his address. One person might manage more than 1 product. Sometimes this person migth move to a new location and change his address. Thus, the form I have created now would ask the user for...

yup thks alot for ur help!