Search results for query: *

Thank you BNPMike anyway. I appreciate your time. Have a great rest of the week and weekend!

Thank you Mike. :) I was mostly interested in how I could use it with Access. For example, can I bluetooth images from a camera to an image frame control on a form? Right now I am transferring images from a Kodak Easy Share camera to a tablet PC to the folder where my project database is saved...

Hi All, I noticed that the new version of Access has a bluetooth add-in. I wanted to find out more information, but cannot find anything online so far or nothing in the help file. Has anyone read anything about this new add-in? thanks in advance!

Thanks TheAceMan1 for helping me again! I'm not sure what this code would be doing. How does the new record get created? By just double clicking in the combo box control? Not sure what you mean by however you supply your PK? Double click record selector? Sorry for all the questions.

I tried the recordset clone and it is not working just right either. Thanks!

Hi All, I have been wrestling with this request for a couple of weeks. I have a single form view form in Access 2003. I have been asked to make it so that the user can duplicate (copy, ditto) a record in the details section of the form (subform). I found Allen Browne's code and some example...

I did TheAceMan1. Thanks again!

...me. SELECT TMD.[HOMOG_MATERIAL_ID], TMD.[BUILDING_ID] FROM tbl_material_description AS TMD WHERE ((TMD.building_id = "Garage") AND (TMD.[HOMOG_MATERIAL_ID] LIKE "bb*")) ORDER BY TMD.[HOMOG_MATERIAL_ID]; I took the breakpoint and it worked!!! Yeah!! Yeah!! You just made my weekend! Thanks a...

...this group and by having to do it on my own. I tested the code; I put some breaks and step into the code. I searched for homog_material_id = BBA* for the BUILDING_ID = Garage. When I clicked on the cmd button it did nothing. I can see all the results for the building id I requested. I want...

Thanks again Ken. The building_id is text; alpha numeric info can be captured. I did add the single quotes and it still did not work.

It did not work this time it gave me no results. Now the HOMOG MATERIAL ID is text but has '-' in it i.e. BBA-01. I seem to remember a hyphen is a special key so I need to refer to it differently. Thanks for continuing to help!!! :)

Thank you Ken. I have it working, but it does not give me only the materials for a particular building. I want to incorporate in this WHERE clause : wherestring = "WHERE(((tbl_material_description.[HOMOG_MATERIAL_ID]) like '" & strWildcard & "'))" this WHERE clause: WHERE...

...Else strWildcard = txtSourceKeyword wherestring = "WHERE(((tbl_material_description.[HOMOG_MATERIAL_ID]) like ""*" & strWildcard & "*""))" FormIndex.RowSource = "SELECT tbl_material_description.[HOMOG_MATERIAL_ID], tbl_material_description.[BUILDING_ID] FROM...

I have a date and a time column in Excel (2003) and I want to assign a period from 1 to 10 depending on a date range and time cut off. Would I need to concatenate the date and time columns into one column? For example, period one would be 5/2/2006 12:00 thru 5/16/2006 12:00. Cut off date is...

Thank you! I saw this article in my search, but cannot get it to work. So was looking into alternative ways.

Hi All, I have a main form with four tab controls. In each tab control I have main form/subform(s) combinations. I have a listbox search in one of these tab control main forms for the user to search the records previously entered on that form (they do not want to use the record navigation...

Thanks SO much 'JoeAtWork'!!! It works great! Have a good one.

So is why it is not working? I am sorry new coder here, but learning a lot thanks to Tek-Tips!

I'm sorry I don't understand. I thought it was populated by this piece: wherestring = "WHERE(((tbl_material_description.MATERIAL_ID) like ""*" & strWildcard & "*""))"

...form called "txtsourcekeyword" the user can search for a particular MATERIAL_ID (CDW-01;text field)if he/she knows it or enter wildcard info CD*. The list box 'FormIndex' should then be filtered to show all the records with CD* and it is not doing that. Any ideas? If I understand the code...