Search results

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, 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