Recent content by pjustin1

Hi, I tried to create a dynamic query where the user may search by any combinations of the 3 input fields. It's still not fully completed but i have encounter some problems.. i wonder can anyone help me out.. thanks... "****" is where the problems lie Dim dbs As Database, qdf As QueryDef...

Hi, I run the delete and append queries from a click of a button, but warning messages(results of delete and append queries) keep popping out.. is there anyway to hide or remove all these...? coz, i don't want to let the user to go through these stages.... btw, i use macro "openquery" to run...

Hi.. thanks for the solutions but none can work well... for the 1st solution, me got this error msg "You enter an invalid expression that has an invalid reference to the property Dirty. The property may not exist or may not applied to the object you specified." for the 2nd solution, it still...

HI, let's say when I made some changes to the data display in the subform, later I decide not save the amendments.. how can I do it? I try using "undo record" but cannot.. DoCmd.Close also can help.. the amended data is saved in any circumstances.. plse help... thanks juzz NB: I need to keep...

Hi, I am trying to add a auto running serial number to my subform which gets it records from a query.. how can i do it..? Or should I include this serial number to the query instead..? I have no idea of how to do this also.. plse help.. Thanks juzz

How to pass result from a query to be display on the sub-form where the query is perform on the same form? E.g like when I enter a value into field1 and upon update, the query will run and the result will be display in the subform directly.. Thanks for all the help Justin

Hi, I want to delete all the records in a table after sending these records to a report named as "MonthlyBalance" when I click a button. I written the following codes and I knew there is something wrong but I don't know where... can someone plse help me out with this? Here, I assume the field...

Hi, I have fields in a table which will store the time and date of a record when it is added into a table. Is it possible to make a query to get the all the latest records these fields and output it to a report? What commands or operaters should I use to make this work? Or do I need to use...

Hi, I create a form through VBA, using the code I shown below.. How can I set macros which I had created earlier into the events properties of the textboxes and commmand button too? Thanks.. Set ctlText = CreateControl(frm.Name, acTextBox, , "", "", _ intDataX, intDataY) Set ctlLabel...

Hi, I trying to create a new form using VBA and this the code below is what I had done... But the form popup is in design view.. how can I make it to be in Form view? Is the code correct? what else should I add or is there a shorter method? Thanks Dim db As Database, newTable As TableDef...

Hi, I have a situation like this, I need to have a form which can display all the fields in the table, where the total number of fields are subjected to change.. Is there a way to do so? Thanks Justin

Hi, In my form, the user will define the field he want to search for and edit the data from a table.. I guess I need to convert the user-define field into a field type in order edit the data.. coz it cant recogonize it as a field. so is there any way to do a conversion? or is there any...

Hi, In my form, the user will define the field he want to search for and edit the data.. I guess I need to convert the user-define field into a field type in order edit the data.. so is there any way to do such a conversion? Thanks Justin

I use a form to open another form and I want to pass values from the first form over to the second form and display it on the second form.. is this possible? I guess I need to use VBA, can someone give a simple example for this? Thanks!

Hi, I need to add new columns through the input from the user through a form, is this possible? and can I later display all these added fields in another form? Thanks Justin