Search results

You can do this with an update query. Have a look for left, mid and right in the help. Q

Can you post the SQL for your query?

Glad I could help :cool:

I've attached a database showing the query Iwas talking about previously. Hope this helps. Q

What is App.Path set to?

Without seeing the database, I'd hazard a guess at a date field for the start of each placement? You could use this to filter on. Q :)

Query Table fees and your table with all sudent ids, linked by student id and show those records where fees.studentid = null.

Hi There OldBirdman, Sounds like a null value. What is it you are trying to achieve? The .value contains the last saved value of the field where the .text is the currently unsaved content of the field with the focus. The VB help for "Text Property" would be a help I think? Hope this is some...

Hi All, Apologies if I'm posting in the wrong forum. Not quite sure whether this should be in tables or forms. My question is, I have two tables, one containing general data and one containing data used to populate a listbox. I want the selected value in the listbox to be used to populate the...

Is there data present to populate your form?

Sussed it :) Hi All, Sussed this one on my own. UNION query. :)

Hi All, Being a newb, have a hopefully straightforward question. I'm writing a vehicle management database which covers eleven seperate areas. The data is currently contained in a spreadsheet with eleven seperate data sheets, one for each area. My thinking is I use linked tables as the...

Hi Again, Many thanks for the responses. The report does run ok on its own. I've managed to get it to a point where the main and subreport run ok together by removing the call to a macro. Have a feeling though, that I've circumvented the problem rather than solving it. Regarding the spelling...

Hi ya, Thanks for the reply. Yes there is data in the tables. Basically the subreport is a summary sheet for the main report. Thought using a subreport would be the simplest way to do it. One other thing that might be relevant is the subreport has a macro in it to zero a counter every time the...

Hi All, First off, excellent forum. Found many solutions here already but this one's got me stumped. Hoping there's a jedi here who will tell me it's easy. I have a report with a subreport in the header. Without the link fields set, I get the "The report name "report name" you entered is...