Search results

Well, I just realized a bug - This line If i > 1 Then should be If i > 0 Then Please change that.

Okay, here's a revised version. Do lots of testing for bugs. Maybe if I have time tomorrow I'll help you fix any bugs.

Well, it doesn't sound too bad, I think we can just do INSTR to get the position of the slashmark and then use everything up to that point as the surname...

I think I'm beginning to understand. Ok, so my solution won't work, but you might want to take a look at it, if you need some pointers (attachment).

You might want to have a list of all possible salutations so that the logic can detect them. Not sure why that would be a problem. I am not replacing the spaces, just the slashes.

Secondly, can you set a definite limit on the number of columns? Or does the number of columns need to be determined dynamically?

Run a query that replaces the slashmarks with a space (the result will be that you now only have one kind of delimiter). Then do the split. Question is, is every line guaranteed to have a salutation?

Re: Reply: Query Help I use Access 2003, but I still think my sample is relevant to your question -and it doesn't take much code. I only used one line of VBA code to produce that sample, everything else was selected from wizards. It allows the user to type in multiple pay_IDs. Any reason not to...

My upload was just a sketch to get him moving in one direction or another. I wasn't suggesting he set up his tables in the same way I did. I was just showing him the general idea of how to use subforms to attack this problem.

Attachment: Open form1 in the sample. The user can type his Pay_IDs into the bottom subform and then click the "Results" button. The results will display in the top subform. In this sample I only joined two tables but it would probably work just as well if you put three tables in the JOIN...

I'm going to upload a sample.

I'm guessing you should create a table called UserTypedPmt_IDs with one column called Pay_ID and bind it to a subform visible to the user (he can type his receipt numbers into the table as displayed on the subform). then you might be able to join this table to other tables (I'm not sure as I...

As the other poster said. You don't want quotes around numeric fields sql="select * from Jobs where jobno = " & Porderno & " and code = '" & Pnims & "'"

Ok, here's a solution using a VBA recordset - that's the best I can do at the moment.

Just upload the whole db if it's less than 100 MB (preferably zip it) - only do this if the data isn't private material. If it's more than 100 mb (I think that's the limit on this forum), you'll have to remove some tables or data. Actually I put your sample data in a spreadsheet - that should...

You say you want it based on the top values (in DESC order). But then you wrote this sample which is NOT in exact DESC order: So the first problem is that you seem to be contradicting yourself. The second problem is that you want to alter a value on the fly based on a computation - you say if...

For eample, one technique I used in the past was to add a boolean column called "Deletable" to both tables. This takes multiple queries: - ALTER TABLE table1 ADD COLUMN Deletable YESNO - ALTER TABLE table2 ADD COLUMN Deletable YESNO - UPDATE table1 SET Deletable = False - UPDATE table2 SET...

Again, you're trying to delete from two tables at once. DELETE Table2.*, Table1.gid Unfortunately, this generally can't be done unless, as you said, you enforce referential integrity. Also, I'm not sure why you are specifying a single column: Table1.gid You can't delete a column like...

Maybe part of the problem is that your DELETE statement is trying to delete from two tables: DELETE tblFinancialTransactions.*, tblTransactionCase.intPaymentID

Private Sub Submit_Click() Dim QueryToSubmitData As String Dim QueryToSubmitBlank As String If Me!WhatToDo = "Add Employee" Then If IsNull(Me.DeptCombo) Or IsNull(Me.FirstName) Or IsNull(Me.LastName) Or IsNull(Me.Limit) Or IsNull(Me.EmployeeID) Then Me.ErrorNotice = "You have not filled in all...