isumasama

Hi, i've googled and found out that the max storage of MS Access 2007 is ~2GB. My database suppport attachment, so hypothetically, if the attachments after insert >2GB, how can I allocate more storage to the db? is there a way?

hi all, i have created a crosstab query and one of the row heading contains a hyperlink field. my problem is that the field is not working, and on top of that it gives corrupted values too. pls help thanks

hi all, i need to do a record search in a form where its Record Source is Operation, but instead of searching the Operation, i need to search different table, say Remark.. i supposed the red highlighted code should be the place to set the Remark table, but how to …

hi how to do insert ignore in access? is access support this function? [CODE] CurrentDb.Execute "INSERT IGNORE INTO FullDB (IDProc, IDOp, IDTech) VALUES (" & IDProct & "," & IDOpt & "," & IDTecht & ")" [/CODE] or how can i do a search for duplicate record first before insert? …

hi all, How to check if a particular row is exist before inserting it? my table has ID as Primary key, and 2 other columns, say Process and technology.. thank you

hi i have this form, and a subform datasheet.i need to copy selected row/record from the datasheet to the corresponding textboxes. i have used this, but it will copy the whole column title and the record, and i dont know how to separate the string of copied data into textboxes, …

Hi all, I have a table where it stores Process. The Process has each processNumber which is unique, & the processNumber indicates the step of a procedure. My problem is, user request to add a Process in between existing processes. In other word the new Process overwrite the existing process …

hi pls help me on this.. i'm using this code to get data from record: [CODE] MyNum1 = DLookup("[Outcome]", "Remark", _ "[IDRemark] = Form![SelectTxt]") OutTxt.Value = MyNum1 [/CODE] my prob is when the data in [Outcome] is null , access having error to still get the null value from the …

How to implement hamming code in C++ or C I have a prog same as other user (Melissa). I need help to get me started in coding as i'm almost forgot everything i've learned on C or C++. The task is implement a program for any hamming codes by using …

hello i have a form where it has multiple checkboxes, and its up to users to select or unselect the checkbox. then user have to choices to go back to the main page; ok and cancel button if clicks on OK, the program works fine but if clicks on CANCEL,, …