Recent content by telephoto

Duane- thanks again. OK, that removed the delay, but what is the permanent answer? delete all printers (3) and reinstall? I wondered if it was some weird MS365 update that threw a wobbly, is this common? Thanks again Telephoto

I have been running a bowls club db for years without problem. I now find I am getting an error message whichever report I call. "Please wait for printer connection or cancel connection" If I click on cancel - surprise - it cancels the request. If I leave it and wait then after some seconds the...

Hi again Duane So simple. The word I did not think of at all was Cascading. The word I can think of now is thanks. for your direct reply, and help in the past, please take another* Telephoto

Skip Postings crossed. Screenshots were taken at the end of a long day, and you saw one where I had been testing using City Ely (which worked). Club name is City of Ely. Again apologies, in part blame the time difference and a long day which started by taking my daughter for an early train. T

Andy If that was the case then Ucase() would not work. It did, and was a better workaround, hence your star. Skip Apologies if I am not clear enough, or frustrating, neither is intentional. I have just spent 2 hours trying to get your options to work. Amending it to one table, had I received it...

Andy Valid point, well explained, I was wise to that. Search variable was set by targetclub = Application.InputBox("Click on team name.", Type:=2) Only ever checks what is on the spreadsheet. Checking City Of Ely =City Of Ely works, Checking City of Ely= City of Ely doesn't work. Telephoto

Thank you to both, Andy First I tried several debug prints for targetclub throughout the module, all were correct I checked the if/then line step by step using F8 and hovering the cursor. Both sides matched but it stepped directly to endif. Using Ucase is a much simpler work-around than I used...

Hi guys Background: Every year I receive a schedule of sports matches for the whole division, sorted by date. (This could be anything eg soccer, but is actually bowls) First thing I want to do is make a list of my team's matches. VBA to the rescue. I examine each line of the spreadsheet for my...

OK, I surrender. :) I tried this over the weekend and it failed, since then I have been a bit tied up, and I just attempted it again. You are both correct - it works exactly as required. Thank you. Telephoto

Thank you. I have been working with version 2003, but application.inputbox is on 2013 and higher. works as required. Please find star. Not all the club match secretaries will be running 2013/6 does anyone know a way of doing it in 2003? T

Thank you for your response Combo,unfortunately I am still puzzled. 1. There is no Userform, I copy the worksheet and work on the copy. 2. Using Inputbox, the only way I have used this is as type input, this is how I am using it in the first version: targetclub=Inputbox("Enter club name") What...

Hi guys, not something I've tried before. Situation: I play a bowls league, several teams in the league, and the organiser produces an excel sheet showing all matches. In order to compile our club's annual handbook I only need our matches. Progress to date: Using vba I copy the current sheet (to...

Hi Duane, again! Many thanks, I just copied and pasted everything from Current into On Activate and it works like a charm. Graham

I have two tables, tblCustomers and tblMachines, now all machines should belong to a customer (foreign key), but due to a table design oversight some machines are orphans. In order for my client to find these I have inserted a routine at the switchboard "form current" event to check for...

Hello to both. Duane, it's been a while - how was Switzerland? I've awarded a star each, between you my problem is solved. Using Docmd.Openform ("frmname",,,,acFormAdd) generates the compile error. I must define "frmName" as a variable, then Docmd.openform stdocname,,,,acFormAdd without ()...