Search results

Hi, When I enter data into a form I would like the data to be inserted into two tables. So I have; TableA1Header (MainForm) TableA2Lines (Subform) TableB1Header TableB2Lines The form that is created is inputting the data into tables A1 and A2, I would like the same data to go into B1 and...

Hi, Am working on a database that will hold some data for two departments. The data from dept1 is entered, when entered I would like it to pass to dept2, so I have four tables say; dept1header dept1lines dept2header dept2lines I am able to get the header information from the input form aka...

Hi, That's great, wrapping the problem strings using Chr(34) solved the issue... Many Thanks Karl

Hiya, The string is returned in full, this would indicate that it is a problem with the C# application that I have created to send the emails. Thanks for the help.. Karl

Hiya, Thanks for the response. Its past to a small application I wrote in C#, the remaining part of the VBA in access is the following; stAppName = "C:\SendEmail.exe" Call Shell(stAppName & " " & stEmailTo & " " & stEmailCC & " " & stOrderNo & " " & stItemNo & " " & stQty & " " &...

Hi, I have a small bit of VBA code that looks up form fields and the data within those fields is set to a string. The problem is some of the data within those fields has a space, any data after that space is missed the full string is missing. Dim stAppName As String Dim stEmailTo As...

Hiya, When I call the Shell command "strAppName" which is to the program location it will work, when I try and add in references to feilds\values within the form am unsure how to proceed. This is how I have tried to reference the feilds and data. Dim stEmailTo As String Dim stEmailCC...

Hi, I have built a small application to send emails in C#, I am now trying to get it to work in Access. If the email address are hard coded into the C# app and a button pressed in Access the emails will send. I have changed the C# app to accept arguments ie a To and CC email addresses. I am...

Hi, Thanks for your help... After playing around I see that you are right, queries just need a bit of extra work in the direction you talked about. Thanks Karl

I see what you mean, if you look at my screenshots you will see that within the tblAirports there are no related records for Flights yet if there is only a link on the departure_airport field then the records are seen. The screenshots will explain better... To me this breaks the relationships...

Hi, I have done this, when I add the second relationship the first will break. When I open up the Airport table and click on the records because of the first relation I am able to see all the flights related to that airport, but I lose that when I add in the second relation for the arrival...

Hi, I have a question about the design of tables and relationships... What’s going on is I have two tables, one is say Flights, and the other is Airports. I have a departure_airport field and a arrival_airport field, I have a one-to-many relationship on the departure_airport field, what’s the...

Hello, I have started to look at the update query, this seems to be what am after... However I have tried to run the dlookup and I get the message unknown. Here is what I have; UPDATE Lines SET Lines.[Desc] = DLookUp("MMITDS","AMBITEMDTL","MBITNO=" & "PartNumber") WHERE (((Lines.[Our...

Hi, I am using Access 2007, but will mainly be run with Access 2003. Normally the part number would be typed in, after its in the below AfterUpdate code would lookup the data required for the description and enter it. Because the data has been imported in from Excel it has missed the...

Hi, I have a sub-form that is in the datasheet view, am using an Excel form to import the data after the import some of the AfterUpdate functions are being missed so I have made a button to call the AfterUpdate function. The problem is that the button works but for only the selected line of...

Hi, I have a problem printing forms that include charts, the problem is not with access but with the printer. A number of printers have been replaced and on the new ones we are unable to print charts completely, some of the data is coming up in black boxes, this appears to be the print driver...

Hi, I have a form in Tabular view, this form is based on a query I have added a button to the line of data so when pressed it will update the data in one of the fields. The field am trying to update has data within it, this field is also used to select the data in the query, what am trying to...

Hi, No problem, it’s always good to be shown something new... But what I have placed in Access is working for me, the OrderID is stored as text due to its format of 111111/11 KAR maybe this is why it is working with the above code. I have tried out the way you have put and that also works...

Hi, I have managed to implement auto line numbers using the above website, here is the change that was needed. MyCounter = Nz(DMax("MyCounter", "OrderDetailT","OrderID= Forms!OrderF!OrderID")) + 1 Thanks Karl

Hi, After having a talk with the people using the database they have agreed not use line numbers but will look into why the data doesn’t maintain its order of entry. How ever I have been working on something that I found and would like some help in understanding why it isn’t working...