Search results

well, this is actually exactly how the relationships of my table are set, but I still doesnt work. Everytime I select one or more products in the product subform for a client, the selection is stored, but when I want to enter investment data on the investment screen, it doesnt show me the...

Thanks for the reply. Your analysis is indeed correct. However, I would like to ask, what are PK and FK indicating? Thanks, A2k

I found it myself. The difference between those 2 tables is that one ID field is a numeric value, hence does not need the " ' " in the code. this one works fine now: strWhere = "[ClientID] =" & Me.[ClientID] cheers, A2k

Open form to a specific Record, but show all records? Hi, I have 2 forms, which are showing me my client information. the form Client List shows me only few information in a list, the form Client Details shows me detailed information for a specific client. when clicking the ClientID field of...

Hi! I have a problem with a relationship between 3 tables. I am using the tables clients (with all my clients), products (with my 6 products) and investments (of each client for each (!) product) to keep track of the activities of a small investment company. Since every client has bought a...

Hey, I am running in a strange error since using a 2003 database under 2007. When I am trying to send an email, which will pulls the body from a table and then replaces certain keywords with specific data, I get an error the used ReplaceVariable() function is not defined. I use it under 2003...

SOS, you are my personal Jesus, thanks man ;) Just one last thing. Since you deleted my query, I had to adjust some links and references in my other forms. Now, all of a sudden, my form which is listing all the clients, does open the client details form, but uses this form for the respective...

as you wish. enclosed the file. Please note that it is 2007 only. THANKS!! A2k

OK, I used the search engine of the forum and found several related threads, but since I am not using any macros or anything special, it all does not really apply to me. I am using a query to pull data from totally 3 tables (which are all related amongst each other), but now find that when I...

@ statsman thanks for pointing me there. the first problem with the expression error resulted due to the a text field in the investment table. solved. the second issue about the multiple products per client, I simply solved by relating the products tabel to a seperated client id, showing me 2...

Hello everyone! to make it short and simple, my total working experience with Access comes down to 3 days now, in which i successfully imported tables, designed forms, made queries, etc., so actually am quite successful, but now definitely am at the end of my knowledge. I am currently working...

Ladies and Gentlemen, I am stupid. Instead of letting access look for ' * ' I maybe should adjust it to '*'.... but I give myself credits for figuring this out :D :D :D THANKS A LOT for all the help. without you folks I would have never come this far! Cheerts, A2k

I tested with transferspreadsheet and it seems to delete the field status of the notes column, hence no preserving with this command. However, I tried the DoCmd.RunSQL "alter table " & Category & " alter column [Notes] MEMO" solution but ended up with an error stating that access cannot block...

great, its working now, thanks a lot! I just have one more little problem. When importing the data, the field type of the "Notes" column, which is originally a Memo Field, is reseted to Text-Field, hence the whole replacement of the * symbol and line break insert is pointless, since a...

One step closer to success now, thanks :) now i get the error that access cannot find the variable "Category", although it is defined as a string earlier on in the script. Category is defined in an inputbox and serves as value for the name of the worksheet to import and as the name of the table...

well, I admit that I was experimenting with the syntax as I got an "Expecting Command End" error when using SET (see below) Update Category SET [Notes] = Replace([Notes], " * ", Chr(10) & Chr(42) & Chr(32) ) As a result, I tried to pack this whole thing into a query, which was suggested by...

so, HOW do I make access understand that I want everything, ie. treated as text type? How do I write that into the code? I dont know about such a reference.... Besides, I am not really sure it is the import, rather the replacement, as this error occurs in the above highlighted area which is...

Hi, i run into a type missmatch error while I am trying to import data from a closed xls workbook (with success), but get the error while trying to replace content of a memo field in the newly imported table. Sub GetDataFromClosedWorkbook() Dim xlApplication As Excel.Application Dim...

there is a need for a variable if I dont know which table needs to be updated.

well, I am getting a bit closer know. I have tried a different approach, since you mentioned that variables for tables are not exactly working with this query, hence i have splitted the query into two (that apparently worked for someone who had a similar problem, but he complained he could not...