Search results

great... how would i compact this. I may have 255 values... but they are not all in that table. IS this ok. ?

I get a message stating that i have too many fields defined in my table. I even tried to rename an existing value in that table but i still get this message. What is causing this ? Help

thanks for the advice... i am still getting the error however: It gives me error 2486 Option Compare Database Private Sub Form_Click() DoCmd.Close End Sub Private Sub BEditProducer_Click() On Error GoTo Err_BEditProducer_Click Dim stDocName As String Dim stLinkCriteria As String...

I have to close out Access entirly for Queries and Reports to close I recieved a message saying that i was refrencing the same thing 2 times in the code for that query. As a solution (not a very good one at that) i deleted all of the VBA that was created when i used wizards to create buttons...

Thanks for the advice... this is a definate step in the direction of my problem. Sorry, sometimes my text is rather cryptic. You are right I have a table that is static, 1 row. I want to pull values from specific columns from the single row. The Query that i am pulling the information to is...

would i have to place that code into the query directly... or can i reference it remotly >>> Could I pull from a cell in an excel sheet or existing access tables cell. I have run into import problems with memo fields from excel (255 character limit) so i would like to avoid this approach.

is there a way to make a default value the value of a single "Cell" Either from an Excel sheet or an existing memo field in an Access table. If so how would i go about doing this. Thanks.

i am using 2k.... it is not for an asp page but that is what i am working this database towards (any good resources ?) For now however, i am trying to sandwich data with the snip table (which only has 1 row) I guess i should make another table, link each single column from the snip table as a...

i am trying to build a non editable query with multiple tables combined. . . i have 1to1 and 1tomany tables successfully combined. I have a seperate table with no relationship to the others that i hold "code snipz" (htm code and javascript snipz) that i would like to place in each row of the...

Thanks for your input. The reasoning for my structure is that one SKU can have multiple producers. Thinking about this more, i reallly dont (think that i) need multiple row values for each producer SKU(s) have ProducerID1, ProducerID2, Producer3.... but not that often. Is it possible, (or a...

This seems to come up a lot and i am really frustrated. I have a fairly large table with a primary key of SKU certain SKU values share multiple producers, categories, ect. I have a table set up Many2Many to deal with these. They are attached via the SKU and the PRODUCERID, ect. I would...

is there any way around this..... 127 characters... .this is vital to me to have.

i dont need it to look pretty... i just need all the information

it is to export out to an excel document.... i just need to do this once. . . and the query would be used for that purpose. Can you export Reports to XLS, CSV, ect. ? ? Thanks.

DescriptionAll: "General: " & [Copy] & "Atheletes: " & [Riders] & "Locations: " & [Locations] & "Bonus Material: " & [Bonus] & "Review: " & [Review] this is a SQL i made in a query to combiner several fields into one to print.... all the fields that i am combining are MEMO... but it seems...

Simplified things a bit Ok... taking it to this level.... should i just combine all into one sheet so that forms will work correctly or should i link 1 to 1 with Cascade delete enabled. ?

generally, this database is going to be used by apprx. 10 employees to update information for upcoming titles [videos and DVDs] Reading "Running Microsoft Access" i came to believe that seperation of the information is important so i made my tables as specific as possible. I will be using...

Overkill I dont have any redundancy in the tables except the SKU field which i have designated as my primary key. Is this not the right approach ... putting SKU in every table ?

I have attached a picture of my tables / Relationships. I would like to create a form that fields from many tables. I have created a query to combine all info to pull into my report but the form is not editable. All my relationships are 1:1 and i have checked properties of each field in the...