Search results

Hi Access Blaster, I am trying to scan a barcode from the tool and saves that in an access form in the field called "code".

Thank you. haa haaaa, I am not hiding anything. I was thinking to do a quicker way of data entry in an access form. We have replaced couple of hundreds tools with the new ones and I have to enter all the tools in the system good thing is that they all have barcode and I can get a barcode...

hi, I have 100's of new tools in stock and I am trying to save time by entering the 10 digit code including text and number in Access 2007 table by scanning the barcode instead entering them all manually. idea is to scan a bar code and the code is stored in a field called "Code" and later on...

hi thanks for the query. but I am not sure where to put this code ? I mean which field.. :confused:

thanks Paul, I have attached a simple sketch of the database which I am thinking, I want a report where I enter an order number and it give me all those fields where the required field is ticked. (please check the table) and should not give those items which are blank. not sure how to go...

hi, I am trying to design a form or report where I can print the records marked with Y/N, but not sure how to do it? could anyone please help !!!!! thanks. :confused:

thanks Sorted.

is there any effect by using the Switchboard ? I am opeining the forms via switchboard.

hi Paul, how to set the tag property ?? I added the code in the on Current event of the form as well?

Hello ! Need help again from the group please :mad: I want to password protect the second tab control page, so I'm using this code : Private Sub TabCtl0_Change() Dim strInput As String Dim ctl As Control ' Hide controls on tab until correct password is entered For Each ctl In...

Hello ! Need help again from the group please :@ I want to password protect the second tab control page, so I'm using this code : Private Sub TabCtl0_Change() Dim strInput As String Dim ctl As Control ' Hide controls on tab until correct password is entered For Each ctl In Controls If...

Sorry about raining of questions : how could I do that ?? I mean what the code will be, the table reference will be same ?? e.g. if add both fields in a same table and how I will enter the data? SELECT [tblStore].[StoreID], [tblStore].[strStoreName] FROM tblStore ORDER BY [strStoreName]...

Thanks Paul, can we do this function from the same table ??

can we do this function from the same table as well??

That's Great ! but when you created the combo boxes the wizard ask you where to choose the values from, do you select the table in the wizard or just draw a normal combo box and then assign the Row source ??? this is the bit where I am always confused.

Could you please explain a little bit...... I am a little dumb sometimes>>

hi Paul, I have attached the database for your review. I would appreciate if you could help me that would be great. thanks

hi Paul, could you please check the above ?? thanks

Please see below: tbl_complaints: ID (Primary Key) Complaint Type (Text) tbl_complaints_Details: ID (Autonum) Title (Text) Description (Text) Complaint Type (Foreign Key to Complaint Type in tbl complaints. Row Source = SELECT tbl_complaint_Type.[ID], [tbl_complaint_Type].[Complaint_Type]...

hi Paul, I have checked the same links but couldn't understand the function. basically I have two tables one with complaint Reasons and other is the detail e.g. select a reason called "Damaged Goods" and the next combo box will open all the related reason for this which could be Damaged in...