Search results for query: *

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 ()...

Greetings all - it's been a while. I have a form designed to show records of a customer's machines. I open the form from another form using an SQL string to show the customer's info required. This has a global variable set as SqlSet2=true. The form on open checks the sqlset and opens to display...

hi Guthro The situation is "resolved" inas much as I have walked away... Thank you for the input, I was unaware of any group like that. In fact I do have access to the originals, but the conversion I was looking for was in the other direction. T

why should I have doubted you? For anyone else's benefit the code (inside a for/next loop) now looks like this: If Not rst.BOF Then rst.MoveFirst rst.Edit rst.Fields(1) = txtMachinePhone rst.Update...

Hello MajP Tried it in various positions for some time, then the penny dropped. The table will only ever have one entry, so it will always be rst.eof = true Shame, because it seemed so obvious. Do you have any other ideas please? T

HI (again) I have data to be inserted into record. The record will be in one of two tables. I have the vba to update the table by searching the table and editing the field If the record is not in the second table Access stops at rst.movefirst with an error message. (because no record) How can I...