Search results

Hi All, For access 03. Since I wasn't sure if my question was being answered in my google searches, I figured I'd run it by this audience. My problem is my text data type field in my linked table can only store 255 Characters and that isn't enough. I believe Memo fields in a table can hold...

You know what guys, Yes works...for some reason I think my database was hanging up. I went to lunch so I closed it out, reopened it and tried Yes since I found your same answer on a website and it worked. Sorry to waste your time...but thank you much for your help!

In my table i have a field called "MinorityOwned" with Yes/No as a Data Type. In my Query, I use all of the fields from my main table (only table used) including this field. So basically, my Query is exactly like my Table but it is in Query format so I can play around with the criteria and set...

Thank you all for your quick responses. This is a query linked to a table therefore it is a "Yes/No" Field. I tried "Yes", "-1", "True" (all with and without quotes) and when I do that, i then go to table view in the query and it forces that field to be Yes or Checked for every record in my...

Hi All, Access 2003. Very Simple...I have a query that has about 15 fields. One of the fields is a Yes/No Box...I want to create a search that returns all the records with a "Yes" selection for that particular field. In my query, what would I write in my Criteria for that field? I tried...

Wow...I was being extremely stupid...my apologies. Yes this does work with the Autonumber. Is there a way by any chance to export this data to excel, to a specific template that formats the fields better? I know how to export it to excel, but the Time field comes up as "00-JAn-00" for all...

Right I know..so your saying to append the files to the working table...then add the new field "autonumber" and everything will be good? Sounds like it will, but when I need to append the table again (which will be once a day), I'll have to delete that autonumber field, append, and then add it...

Atomic... There is a Date and Time field so that would be unique if combined..

And i just read my post before yours..I should be apoligizing...it makes no sense. I take the Linked Table fields and Append to the New Working Table. The "append to" fields have one extra field (autonumber)..which i think is causing this to not matchup/work right??

Ok, no worries, let me break it down to you a little better. Background info...the behind the scenes dont really matter that much besides there is a Notepad document linked to this Access Database. So depending on whatever is in this notepad document (which changes daily), the databases main...

Also...something isn't right. When I go to create a new query, I first pick the fields from the new table (working) I just created. This is the table with the Autonumber field. I then go to Query Type-->Append Query and it asks me to link a table to it. The only table that shows in this drop...

Ok...thank you for the thorough instructions. Looks easy enough...I have one additional question though. I'm trying to make the lives of the end user as easy as possible. I have a Command Button on my main form that the end user clicks to run a query that is pulled from the working table...

Mr. B, Thanks for your response. I haven't but that sounds like a great idea! Could you explain further on how I would go about setting this up. Basically, I would create a second table (the working one), with all of the same fields as my linked table and just add an autonumber field and...

Ok thank you for the clarification

Ok let me explain further. The notepad document is linked to a Web Form...which retains the submissions from the end users. It is in plain text, and to represent a new field, a comma is used. The program is called Form to File and it does this automatically. For example, Name, Address and...

It's a Notepad document with text seperated by commas which respresent different fields. Editing this document is not possible (it comes from another source).

I have a linked table to a Notepad document in Access 2003. I need to add an additional field (an autonumber) and change the format of a time field, but I cannot since the table is linked. Is there a way for me to make these changes while the table is linked or is it possible to unlink the...

I figured it out, used a continious form. Thanks BOB

Thank you Bob, worked!! Minor Edit tho: DoCmd.OpenForm "frmSearch1", acNormal, , stLinkCriteria Does anyone know how I would show the multiple box numbers returned on my frmSearch1? If you are helping, search: Project: 1234567 Task: 1 Award: 12345 And I would like it to return Box 1, 2 and 3...

Actually, Some of this is making a little more sense, I just need help with this first expression of the code Private Sub Command3_Click() stLinkCriteria = "[Project] Forms!frmDashboard.Text5 And [Task] Forms!frmDashboard!Text7 And [Award] Forms!frmDashboard!Text9" DoCmd.OpenForm...