Search results for query: *

Hi, I make a selection in a listbox (test case list) and press a command button which brings me to another form (test case).But when i save the changes on the the (test case) form then i return to the (test case list)form.I was hoping to have the item previously selected to remain selected in...

Guys, I am really stuck on this one. I am editing field data on FormA, saving it and returning to another form where I should see the data updated. One field in particular. However, no matter what i try it won't update the field until i re-enter again.I have tried requery, form onOpen, refresh...

Hey guys, thanks for all your help the last few days.I am wondering would you know a way of setting the value of a form text box can default to be the current date when they enter a form. I have tried to use onOpen (for the Form) set value be Date() but tells me this is not allowed to be set...

Hey guys, i am clicking a command button which opens a form up. Problem is this form was setup based on a query and therefore it is looking for query details. The user of the system will select some details on a listbox and click this button. I have this statement in the onClick property,[Case...

hi, i hit a "save" command button which saves data on form1, closes it down, then opens up form2.However, the changes i make on the form1 should be reflected on form2. This data in the list box is not getting updated until i reopen form2 on its own.I tried appending to the macro which runs when...

hey, i am trying to print a report (from a form) which is using a textbox value as a query.However, it doesn't seem to be picking up the filter value. It keeps on prompting me for the query element which i have set out in Where Condition in the macro. Any ideas?

Guys, I need to edit a text box (on a form) which is linked to a tables field. But when i add a control source it comes up uneditable. Can i do this it this way or is there some other way i have to go about having a form which allows the user to append to a record. Cheers

Hey, i have a db which uses a selection from a combo box to bring up a new form.A user then makes a selection from a listbox and presses a button to bring up another form. The results on this form are primarily stored (returned using a query), but the user must be able to edit some of the...

Hi folks, I didn't think it was worth just dropping in a few bits of the code as it might be clearer with the whole lot.Basically i am quite slow when it comes to what exactly is being said in programming code. The result when running a command button is i get a #NAME? error.I have highlighted...

Guys, Struggling to get values to be retrieved from a spreadsheet. Someone elses bit of code and am shocking at reading and writing code but you might be able to help. Procedure which is populating a column (number 7) with "Other" if Column 4 is DCM or and column 7 is not populated or...

Guys, I have a listbox on a form which the users make a selection.Depending on what selection they make, a command button they press will "should anyway" use the first column as a filter in a macro opening up a form.I have tried just adding some variations of =...

Hi, Need to get a quick report set up to accept text and enter in db, and upon completion i need a mail handler to be sent out. Does anyone have a quick piece of mail handler code and even odbc connection code would be great as well.Haven't touched vb and access for ages. Cheers

hi all, new to vb script...basically just trying to validate details from a form....trying to ensure that what is submitted through a particular field is an actual email address..beginning with letters,contains one @ sign,continues with more letters,a full stop and then finishes with 2 or 3...

Hi, have very poor asp skills and am barely putting this together....basically i am trying to create a function that takes one argument from a form field, and returns true if the field has a value for an internet email address and false otherwise.....the valid email address should begin with...

Hi, i am not an experienced coder and want to create a procedure that will trim column information in a specific table(and can be re-runable)in MS Access.So if there is a vb sub procedure that i must run i would greatly appreciate it.Cheers p.s When i mean trim i mean removing all the white...

Hi, i am not an experienced coder and want to create a procedure that will trim column information in a specific table(and can be re-runable)in MS Access.So if there is a vb sub procedure that i must run i would greatly appreciate it.Cheers

hi, i have a query that is linking 2 tables in Ms Access and i wanna add some info on each customer that wiil not redefine the search.i.e i have a query with so many records and i want to add info to each record in that query but not retrieve more records.Cheers if anyone can help

Hi, does anyone have client-server code available that i could take...just making a small app and need to have it up and running error free as soon as possible.Cheers

Hi, i have an Access 2000 db that works on my own desktop over the same network as that of the persons i developed the db for.It is a direct copy placed on the network but they have a "object has no control" problem is popping up.I was wondering what potentially is the problem.Cheers