Recent content by pbail1

Delete the row and then insert another. Make that autonumber and problem solved. Well it always works for me.

Covert aFilter to an Int. change the last bit to int.parse(afilter) or make aFilter an int in the first place

Hi MwTv One way to do this is to store the username of the person that put the account into follow-up and when you open the database you can display a form whose contents is determined by a query that takes todays date and the username as parameters. It is easy to set up, but I need your table...

Replace the single quotes with double so line reads: rs.FindFirst "[Client Name] = "" & Me![Combo170] & """

Hi Mrdod Goto the VBA Editor and create your own dblclick event subroutine that assesses the selecteditem of the listview to obtain the ID. You can then do whatever you need with that data to load your form and populate it with data. Private Sub lvwResults_DblClick() Dim lstResults As...

There are a couple of ways of doing this. First is to use the dlookup function to see if there is a record with that ID in the table. EG: If isnull(dlookup("empnumb","TBLCaretakers", "Empnumb = " & strempno) then msgbox "Employee Does Not exist else {Carry on with your code} end if...

Hi Paul To be honest I have no idea if there are any decent threads here as I learnt via trial and error. I already knew how to connect to other office products and it took me two minutes to figure out what to do to connect to word and from there on I used the VBA recorder and good old help to...

Hi Paul Creating a Word document is relatively straight forward. The following code creates an adodb recordset, opens a new word document and adds the content of the field "fieldname" into the document. All you need to do is to ensure that you have word object library and the microsoft...

Hi Peljo Just replace the line: appW.Documents.Open (" C:\be\notes") With appw.documents.add If you want it to be based on another word template then put the file path to the template after the "add". for example appw.documents.add "C:\template.dot" Don't forget to have word object...

Hi xtain Create an ADO connection to the database and then query the data to form a recordset. Once we have the data in the recordset it can be copied directly into the spreadsheet using the copyfromrecordset command or if you want more control over the data, you can cycle through the...

Hi edsuk Can you explain how you get the figures in the second table as I cannot see how some of the figures match the base data above - I can be thick sometimes so bear with me! If it is purely employee X did two tasks on Day Y and total was the cost for task 1 + the cost for task 2 then you...

Hi Johnseya If I understand you correctly you want the counter at the end of the filename incremented each time you save and that you will be saving a new version of the last version of the spreadsheet, i.e. whatever the last partX was created and not the original Part0 spreadsheet? If so try...

Hi Snowcold I have adapted AlexIt's script to import all the CSV files into the same file, putting each CSV file into a separate worksheet. It assumes that the CSV files are all saved in the same folder and that no other CSV files are lurking in the folder you don't want (as this script will...