Search results

I get it now.. Thx for the info, this does pose a slight problem for me though. I hope that perhaps there may be a solution other than creating a form with multipule subforms. I started creating the dB from a .xls flat file. For data input purposes and familiarity on the client side I wanted...

I have created a relational dB (picture included of layout). When I try and create a query and include tblAssets and two or more tables that is in a one-many relationship with tblAssets linked by the AssetId field I can not update any records in the query, wheter it is through a form or query...

So Then str="abcdefgh" Right(str, len(str)-5) Would be -> "fgh" Hmmmm, how would this be applied to capturing certain unknown characters from the middle of a string?

This may help If the format of the string is always the same and the zip is always encapsulated by the bracket then you could use this expression Left([Address],(InStr(1,[Address],"(")-1))

Does it also aplly to... So if I understand you correctly Pat, if I had a main form with a subform on it and the subform was populated with variables from the mainform and I then want to double click a record (or Multipule records) on the subform to pass the record(or Recordset) information...

Some explanation pls I know that your method works (I have found that usually this is the best method to use when parsing strings) But I don't quite understand why it works. I mean I know how the left() function works but what exactly is Len() doing? BTW could you not just do a...

Yipee RichO, you are the man..... Thanks alot

Could you provide a sample? Thx for your quick responce Rich, do you think it would be at all possible for you to provide a sample dB that uses your code in a query. I am very much a novice at this and do not know exactly how I would make the references. Thx

I have a table with a AssetTag field, this has to be split into two fields. ServiceTag and NewAssetTag The current format of an old assettag looks something like this: XX11111111 or XXXX1111 or 11111111 or 11111111XX Where X=ServiceTag and 1=AssetTag I would use Left, Right but the lenght...

I have created an update query, there is a "Floor" field that in the original table lists the building and the floor as a single value (SCC 1st Floor). I can easily remove the building code with a left function, the problem I have though is that the spaces between the building code and...

Pat, please hold off on the dB example (If you where going to do it). I think I understand fully what you mean. I want to try on my own first. Thx again

Thx for the help Pat, do you think you would be able to provide an example dB. If I sent you the dB that I am working on with the flat file. Could you use that to build the example?

More Info Would you only need to connect on field from both tables?

Hi all, I have created a dB to track assets and the implementation of new assets. The data is located in a flat .xls file which i have imported into my dB as a flat table. I want to move the data from that table into the respective relational tables and keep the relation. Aaargh, how do I do...

The only ant. If I was the only person that would work with the dB then I would concider just importing from the file menu, but I am building this for people who have very little dB skill(Less than I do) and I would like to make this as easy as possible. This means creating a form that they...

Newbie Clarification I am just learning VBA an am specifically looking at importing & updating tables from excel spreadsheets. I just want to make sure I understand the code above, can someone tell me if I am getting it right? It seems that the person is first copying data from "Deelnemer"...

Ok, so I now know how to import data from a spreadsheet to access. Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport, _ acSpreadsheetTypeExcel9, "Sheet1", "C:\Temp\Table1.xls", True, "A1:C11" End Sub 1. Can I add to this code to append the data to a existing table? 2. Is there a...

Please Elaborate If I use the "Coded" method to import, could I add a input box on the form where I can specify the file name, how would this reflect in the code mentioned above? Also if I had a button that would allow me to search for the file in a dir structure and then this would populate...

Hi all, I have been asked to create a simple database for tracking assets. This would have been a fairly simple task if not for the data that I have to import into the dB that I still have to create. Before I create the dB I need to figure out how to get the data into it. So far I have 2...

Hi all, I have a table with field Username, the format for the Username is Smith, John A. Not all names have a middle name and some even have a Title. What I would like to do is split these names into separate fields. FirstName, MiddleName, LastName, Title I have used the Left and Mid...