Search results

Hi, It's me again:) I have now just about completed my database and was think there must be an easier way of testing forms. My thinking possibly be a key stroke recorder that I can run on each form to check if the form functions correctly. I had one years ago (on main frame) that you could have...

Can you help I have a FE_ and BE_ database and have tried to convert the FE_ to accde and all I get is Unable to convert message from the helpful MS team :). Can someone help on the possible reasons. Thanks Peter

Hi, Has anyone had any issue putting BE_ on Onedrive? Peter

Hi, I need to reduce my FE_ size, which show I look at first Queries, Forms or Reports or are they just the same. Thanks Peter

Hi, I would like to shrink my front end down, can you tell me which uses the most space queries, forms or reports. Thanks Peter

Good points

Hi, I have just split my database and can anyone tell me why the frontend is 26mg and the backend is only 2mg. Surely the frontend being only text should not be that large? If this is a fact can I reduce the frontend size, I have tried the the compact. Peter

Hi, I have an application that has one record that when clicked will ask for more information. Is there a way where just this one record (table has primary ID) cannot be deleted as I cannot not see how I could use an if statement. Thanks Peter

Hi, I have designed a ms access database for a community centers. It works well but I would like to split and have a backend. However a number of community houses have different drives which is ok with just one database. My thinking was having having a table with the backend location for each...

Hi, I have two email clients Thunderbird (default/home) and Outlook (Work) and use the following to email VBA With olMail .To = CEmail .Subject = vs1 .Body = mm .Attachments.Add "G:\DATABASE\20200924\Login Instructions.pdf" .Display End With However it sends via Thunderbird, can...

Hi, I need to send a number of outlook emails but each email get 'Deny Allow' message. Is there a way to avoid this message? my code With olMail .To = CEmail .Subject = vs1 .Body = mm .Attachments.Add "G:\Login Email Instructions.pdf" .Send End With Regards Peter

Did a ASC check as above and found it was a 160 and according to Google its 'ASCII 160 (non-breaking space), whatever that is'!!!

Hi, There is something at the end of my fields (but only some so I cannot use mid ()) and it's not a space as was thinking it maybe a LF and/or CR. Can anyone tell me how to remove LF or CR from end of line with vba. Thanks Peter

Hi, My issue is this. I get a long email from IT saying they have setup a new email user in the format: Name: Peter Jones UserName: pJones Password: ytrrunnsdge Emailaddress: Peter@jhsdfjkjkf.com.au I need to exctract as variables" Row 1 "Peter" Row 2 "pJones" Row 3 "ytrrunnsdge" Row 4...

Hi, How do you move down a text box on a form that looks like. ASCjkhjkhc ghgshjg hjjkhkjkjkhh jhhjhjhjkhkhj ghghgkjhjk and I need to move down each row and extract data. Also how do you find the end of the row so I can use the mid() function. Thanks Peter

Can someone give me the vba code to send a pdf file that is on my drive to email address. Currently have below for just sending emails. DoCmd.SendObject , acSendNoObject, , strEmailAddress, , , "Welcome to the Outreach!", mm, True but not to sure on attaching a pdf as an attachment. Thanks Peter

Hi, Sorry I forgot to mention that this is imported data from an excel spreadsheet not entered on access. After I wrote this post I thought I may try multiplying the field by 1 then use on error fix it. PS Thanks for all the quick responses.

Hi, I have had a strange request for a database I am writing. We have a string field for a phone number so we can keep the '0' at the beginning of a mobile number. However some people are adding land lines with words such as 'ext' etc. My question can I search for alpha in an alpha string so I...

Thanks all for your help. I have fixed it at the source.

Hi, Can you help. I currently have two tables one that I need to update and has 4000 records and another table with 60 records that has data I need to update the first table. I currently loop thu the first table and dlookup on the second and if found update the record. To do this I need to loop...