Search results

ANy other suggestion Hi Mate Still really slow any other suggestions?

Hi I have developed a DB for work and it has grown, it is about 60Meg, all of a sudden when I am opening Design View in Reports, or queries it started running really slow. I always Compact on Close I have Split the DB. Still no Joy, I have a brand new Dell PC so nothing wrong there. What is...

Hi Ken Sorry probably didnt explain myself properly, I enter all the data in the form. then press new order and the db goes to the next record, but print the Purchase Order of the data i have just entered. I was just wandering there was a way to have a tick box to exclude the printout bit in...

Hi I have a form that creates an order, when you click on [new order] on the form it moves to a new record and it prints the Purchase Order automatically. This is fine. But I want to have an Tick Box which defaults to Yes ( to print ) but I want to be able to Un-Tick this box then when the...

driving me insane hiya, I have set up a query with a condition [Barcode_Dept] so when i double click on my list box it should pass through the value to this condition it doesnt, i am not very good at code so probably messed it up please can you point me in the right direction Private Sub...

Bit of a problem Hi Mate Bit lost on this. I have a Query [qry_ListSearch] that lists everything in the [tbl_ZM_Orders] which has a yes/no field with items that can be repeated on. From this list, I have a search form that lets me select from Supplier and Product and list of lines that can...

Thanks Thanks Mate, will give it a go, sounds about right

Hi I cant get my head around this one, I have a Form that enters all details for an Order. On that form is a Tick Box that says Repeatable. If that box is ticked in the future I am able to repeat on that stock item. I have created a form with a List boxea that Lists all Suppliers Stock that...

Thanks Thank you for that, think I am there, but when I double click a record in that list box, how does it open the form with the record i double clicked?

Hi I have a form, with 2 Combo Box's and a List Box. The Combo Box's provide a search criteria and the results are displayed in the list box [searchList]. I want to be able to double click a record in this List box [searchList] and that will open a from [frm_SearchDisplay] with the selected...

i got it to work I got it to work on setting got focus on a filed that is the first field read on a new record, then on current making the fields visible true / false if that makes sense

Lookup Tbale Sorry a bit new to coding, how do I use a lookup table in a report?

I have a Report that I want to display certain fields depending on data in a field. ( Visible - true/false ) I have created an if statement If Me!SizeScaleGrade = 1 Then SizeScaleGrade_A If Me!SizeScaleGrade = 2 Then SizeScaleGrade_B If Me!SizeScaleGrade = 3 Then SizeScaleGrade_C If...

Just one time Hi I am developing at the mo so just one time changes i think u r right 3 clicks easier..... it works fine that way Thank u for all your help. H

? Yes. there is a list of records there and if a record is allocated i want to double click on the record and change the field ( Aloocated ) to Yes from No, or vice versa

Thank You Thank you again. Do u know if it is possible to double click on a record in a list box, and toggle between yes and no for a certain field

On Current Hi Mate Think i have not explained myself properly. Sorry my fault I shall try again. Orders (Form) has many Order Details (sub form) I enter all the details on the Form ( orders ) There is a field called Size Scale Grade, depending on the grade i pick ( a to h ) certain fields...

Hi I have a list box, one of the fields is a yes/no field. Is it possible to double click a record in the list box to toggles between yes and no ( hence updating the record ) ????? H

Thank u so much Fixed it. Thank u have you seen my other post on the forms forum?

Silly query, think I am missing something obvious but I shall ask anyway.\ I want to update certain lists in my form do the user can select from this list to update a field, so i click on a button and open a table, update a record and then close it to return to the form. the List does not...