Search results

Hi brucey54, I don't understand the need for pre populating the rota table with the Client Name & TelNo as you have a 'n:1' relationship to 'TblClientDetails' already. And 'pre populating' is against all database rules. Why do you want to store the combobox data? You already have them in...

Hi brucey54, seems that nobody takes care of you. So this will change immediately! Open 'TblCarerdetails' in design mode, right click somewhere in the middle, go to 'Properties' and change the property 'Subdatasheet name' from 'Table.TblCarerDetails' to '[Automatic]'. I'm not sure if these...

Glad to help. Good luck with your project.

Thanks again for your pleasant response. The way I realised your automation is - even if it doesn't look like to you - "quick & (middle-)dirty"! There is a disadvantage: remember the comment line "'Open a recordset which contains all records of the table 'InventoryTransactions':" The problem is...

Hi Clifton, thanks to Microsoft, we can use the universal query language SQL in Excel too. Reviewing my code and thinking your wishes over one more time, I found some silly things: my block If rs.RecordCount > 0 Then rs.MoveLast End If is needless because records of a...

Thank you for the joyful feedback. I wonder if you are able to generate your inventory totals now as I did nothing special for it.

Hi Rita, you don't have to be embarrassed about your databases. Compared to others I've seen, yours is only 'middle-messy'. But to tidy a database of this size (primarily the data structure and the code), it will take you a lot of time and effort. --- But for now we try to make the best out of...

Hi, "...put the procedure 'cmdAssignPins_Click' back into the module"?? Why did you do that? At the beginning of your post you say "I deleted the procedure 'cmdAssignPins_Click', ..." If you want the 'pencil' button only, you can remove the 'cmdSave_Click' procedure of course. But you should...

Hi silversun, maybe this wasn't clear enough, but the button 'cmdSave' should not have the caption 'Assign pins' any longer, as it only saves records now. You should change it to 'Save'. The reason, why the pin table update doesn't run is the deletion of the procedure 'cmdAssignPins_Click' to...

And here are my answers: 1. The button 'cmdAssignPins' is not only 'not active' but also not existent (if you renamed it to 'cmdSave'). I told you to delete the procedure 'cmdAssignPins_Click' (and others). 2. 'Exit_Assign' is a jump mark which is mostly needed when there is an error handling...

Hi clifton, assuming you have some VBA knowledge, I would suggest something like this: Private Sub ExportSelectionToSpreadsheet() On Error GoTo Err_Export Dim dbXLS As DAO.Database Set dbXLS = OpenDatabase("[path and name of your Excel file]", False, False, "Excel 8.0;HDR=Yes")...

Thank you for the explanations but I still have some questions. I'm not able to get through it yet. Would you mind to upload your database?

Hi silversun, of course you can execute 'qupdPinsWithInvID' automatically after saving the invoice details. But: "by pressing the same key"? I guess you want to say 'button'. I missed this 'Save' button in your form, so we have to click either on the record selector or navigate to the next...

Hi, tell me if I'm wrong: a 'finished part number' represents the number of a kit. If so, then the users have to create one by adding components to it. I think you will need a third table containing only the component part numbers (and perhaps the quantity), which are a part of a kit, i.e. the...

John, I'm not able to fill your shoes but I will give it a shot... Hi silversun, I tried to get into your problem. I had a look at the attached database and, if I understand you right, there are pins to be assigned to an invoice right after it was inserted. You determine these pins by the...

Hi rayape, before this year is over let's go the whole hog. I think I got it. There are two reasons for the undesired/missing function of your query: 1. the operator 'AND' and 2. the value of the false part of your IIf-statements. If a checkbox isn't checked, the statement returns the value...

To say it frankly, I'm not sure what you did wrong. I started with creating a table to have some data to query. Then I build the form in order to have the control names corresponding to your case. After this I created a simple query (using the access functionality by pressing the corresponding...

jdraw is right, the hole query would be very useful. I tried to figure out your problem and I have to ask: it's really necessary to evaluate both, the checkboxes and the comboboxes? However, I developed - I hope - a solution for the problem. You'll find it in attached accdb file. I apologise...

Hi Spike, if I understand you right, there are both, 'authorisations' with two numbers and some with one number. Therefore I suggest you use two tables, linked by an 1:n relation. If you agree, you can try the code in attached database file. Otherwise you can easily change the code (and the...

Which is the date format of your country?