Recent content by _JSincliar

I have a which combines the results of a few other queries. When I run it, Access automatically sorts it alphabetically on the first column. Instead, I would like it to preserve the order in which the input queries are written. ie, SELECT Content FROM qryFormatT1 UNION SELECT Content FROM...

I have 2 tables, A and B, in a 1-1 relationship and on an SQL backend. With my Access front end, I would like to be able to make renamed copies of these tables on SQL, create the 1-1 relationship between the copies, and link them down to my front end. To make the copy, I was going to use...

The problem was there were no quotes around Me.cboStudentID. I used Chr(34) before and after to insert the quotes. A useful trick I learned here a little while ago. Thanks, Jonathan Sinclair

I have an unbound text box that will update a table after the text box is updated, however I keep getting the above error when the event runs. The query runs if I comment out the where clause, and I can't see where there is a data mismatch. They are all strings, and the fields are Text. Is...

That did the trick, Much appreciated. Jonathan Sinclair

Thanks, that worked great. The remaining text boxes populate when a selection is made. Now whenever I open the combo box, it lists the the columns as part of the drop down. Is there a way to hide those columns and show only the first, and still have the text boxes populate? Although that's more...

I have a combo box that is based off a query returning 5 columns. The first column is the row source of the combo box and I want to use the other 4 to populate 4 text boxes on the AfterUpdate event of the combo box. The second columns' text box fills properley, however the others do not. The...

Any ideas? This is really frusterating. Thanks, Jon

Thanks to assistance I recieved here a few days ago, I was able to re-run my code on each new record's Format event, which essentially would check if certain fields had any content and would make the bound text boxes visible, and move them to a position relative to other text boxes that were...

That seems to have done the trick! Thank you very much.

I have a report with a series of controls, whose visibility and position change depending on the record. When I preview the report before printing, it formats which controls are visible for the first record only, and all other records follow that template even if they need to show something...

Thank you for your responses, and sorry for the delay in mine. @ Mr. B: I am aware that the design I am working with is not ideal and I am willing to work on normalization, however that will have to wait for a time when reports are not needed from this DB. Normally, I would simply calculate the...

I have a table of names and points: Name -- Pts1 -- Pts2 -- etc I have a second table which I would like to store the sum of all the points in a record. Table 1 Name1 -- Pts1 -- Pts2 Name2 -- Pts1 -- Pts2 Table 2 Name1 -- TotalPts Name2 -- TotalPts I am trying to perform the calculation and...

Works like a charm! Thank you very much.

Thank you for your response, I replaced my line with yours but recieved, Compile error: Syntax Error Am I missing a single or double quote somewhere?