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!

Hi TheAceMan1 Thank you SO much for continuing to work this through with 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...

Thanks Ken and "TheAceMan1". I tried your code TheAceMan1 and I broken down for my benefit to make sure I understand what it is doing; I am new to programming, but learning a lot from 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...

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...

Hi All, I have the following code I am wanting to add a WHERE clause and I have tried adding it almost everywhere, but it does not work. I don't get an error, but don't get what I want. Private Sub cmdViewSources_Click() wherestring = vbNullString If IsNull(txtSourceKeyword) Then...

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 & "*""))"

doing? I have been troubleshooting this code because it WAS working last Friday and no longer is. I am not sure why. basically I have a text field on an access form called "txtsourcekeyword" the user can search for a particular MATERIAL_ID (CDW-01;text field)if he/she knows it or enter wildcard...