Search results

Id like to change the properties of my continous form from Allowadditions "No" to Allowaddittions "Yes" at the click of a button Because when the form loads it has that blank field and the bottom, and I dont want to see that unless I want to add a record. What kind of VB will I need to write...

In your subform properties change the Default view to "Continuous Form" That should do the trick.

I just found out about a cool Active X object called Listview. I would like to convert my list boxes over to Listview so I can have conditional formatting for each separate line. I am a little stumped on how you get data into the listview. Any help would be greatly apreciated This is a good...

If you are pulling data from more than one table trhough a query this will happen. In the Form properties find the Property about Recordsets being Dynasets, and change it ot Dynaset(inconsistent) I believe its Inconsistent, Its the one with the ()'s Hope that helps

I have 5 listboxes on a form and I am trying to get them to refresh when they are clicked But the macro I am using you have to specify the control Name Is there a universal name I could use like This.lisbox I cant leave the control name box blank b/c the 5 boxes are set between page breaks...

Im lookin for a textbox that will enable the user to browse for a file. I cant seem to find anything *Its to index the location of a file, not to open one Thanks

I have a combo box for selecting Jobs, and I would like to add a DELETE option or something so if they decide they dont want to add a job they can just select that field and it will dissapear. This combo box will be used with a Continuous form Thanks

In the form properties you can tell it Additions = NO and that will get rid of the line.

Im trying to use an unbound listbox on my form to determine the rest of the information on the form I have a list of Jobs in the list box, and I want to be able to select a Job from the list and have that information show up on the same form under the list. It works if you use a combo box, but...

Ok, how would I tell the Do.cmd.RunSQL to Run the Append Query. The Query is called "Append Schedule Jobs Query" I need the Add Job form to add a Job to the Record, and Also put it on the schedule. B/C I always want the Job to be Availabe but the job wont always be on the schedule. OR should I...

Im trying to Append most of the data from my incoming job form to my Schedule Job Form using an Append Query I would like to Run the Append Query after the Form updates. Or everytime the user types in more information Would this be a macro command or should this be Coded? If its coded what...

To create a form you will need 2 Textboxes and a listbox No button :) The Text boxes should be named the same as the corrosponding fields in your table [CompanyName] CompanyName (The name can be changed in the Properties) Create a listbox that gets its Record set from the query you made...

In Query Design mode add this criteria under your Date Field Between 04/01/99 AND 26/01/99 I noticed that you have your date setup like this DD/MM/YY I Have my dates set up MM/DD/YYYY Make sure you search in the format of the dates in your table

Awesome, Thanks alot! :D

OK cool, I was just reading about the Format(JobNum,"000") property. To get the new job number I query the Jobs table to find the MAX job # for that client, then I will put that value+1 in the [JobID] Textbox and i would like it to look like 003 even though the actual value may only be 3...

Im building a database for a company that has a Client # for each Client and a Job # to go with the client Client# 200 - Job# 002 '2nd job for that client Ex: 200-002 '2nd job for that client 200-003 '3rd job for that client When a new job comes in for that client(200) they will get a new...

Ok, I Just tried that, and that seems to be a little too much, It would just include everything and I couldn't narrow it down. Whats the easiest way to have the form create the SQL script so I can use AND on the fields that are "Dirty" and ig nore the other fields that are empty b/c if they...

Im creating a form to search a database The form has several unbound fields you could use to search The results show in an unbound Listbox StreetAddress, Lot,Block,Section,Subdivision I want the user to be able to type in Kellywood And recieve all results LIKE kellywood Kellywood Point...