Search results

  1. I

    I Identify as Black

    The difference is that males and females are identified by their X and Y chromosomes. A male might emotionally identify as a female but its biology remains male. Identification by race is an artificial construct. For example we can sort beads according to colour but they still remain beads...
  2. I

    WIFI connection without router?

    This is called an Adhoc wireless network between 2 devices A router has to continuously identify which port the packages have to go to which limits its speed. Removing the router from the equation results in a data speed of the slowest device. I don't know if the router is constrained by the...
  3. I

    ADE.

    Solution Using Access 2010, I previously was able to save & publish my accdb files as accde Today, when I tried to publish in the same Folder as the original I received the error ....database.mdb; file already in use. I followed all the advice in this thread: Debug, Compact and repair, even...
  4. I

    Solved How to fix API declaration from 32-bit to 64-bit?

    Thanks. I have been looking for a simple solution for a long time. One interesting effect. After moving the Login form from Edit to Form mode, you cannot go back to Edit mode again since the form has been instructed to stay open. Close the application, open in Edit mode and edit the form...
  5. I

    Convert back to 32 bit Microsoft Access Security Notice

    I appeared to have bumbled my way to the solution for the Trust Centre. On reopening the opject the problem was resolved. When you don't know what you don't know, it is difficult to ask the right question. The button: Before resolution I opened a form in design mode. I added a command button to...
  6. I

    Convert back to 32 bit Microsoft Access Security Notice

    Thank you Colin Interesting how one can spend a lot of time searching for an answer, and as soon as I post I find an alternative method which appeared to work for me at the time but did not. This method was to RegEdit HKEY_CURRENT_USER Software Microsoft Office 14.0 Access Security...
  7. I

    Convert back to 32 bit Microsoft Access Security Notice

    I am running Win 7 and Access 2010 I am have prepared an Application for distribution. I made the mistake of loading the 64 bit version. My first customer has an old PC and I gave her a copy of the 32Bit Runtime. When she tried to open the application she got error Application designed for 64...
  8. I

    Access Package solution error

    Thank you. I will try tomorrow
  9. I

    Access Package solution error

    Using Access 2010 I have followed the wizard faithfully but on clicking OK I get the error message: "The destination install subfolder cannot contain any of the following characters /;*?" and so on My destination folder does not contain any of those characters. I have tried different...
  10. I

    SQL Insert into - unable to pass Value parameter

    Wow. Thank you and much appreciated
  11. I

    SQL Insert into - unable to pass Value parameter

    MS Access 2010 I am adding a single record to a Table PEFDonationsCong with one of the field names CongID which is numeric. A button click is supposed to add the record from the Form to the table Private Sub AddCong_Click() Dim strSQL As String Dim integCongID As Integer integCongID =...
  12. I

    Unable to re-use calculated values in VBA

    Thank you. One can stare at the problem and not see what is happening. I totally missed the point and assumed a wrong diagnosis. Split() is interesting. I guess I would then need to count off the number of addresses then concatenate them. Maybe another day. Now back to the next step of looping...
  13. I

    Unable to re-use calculated values in VBA

    The Problem: Once I use a calculated value in a formula, I appear not to be able to reuse it. Access 2010 and Win 7 I am using VBA to produce a string of email addresses separated by semi-colons. This string ends up with about 250 email addresses, too long to use in the associated Outlook. All...
  14. I

    Displaying a Count in an Unbound Textbox on a Form

    I think you are being unnecessarily complex. Why don't you try a simple query? Your MIS part of the query would look like this: MIS: IIf(Now()<[ResignDate], DateDiff('m',[StartDate],[ResignDate]), DateDiff('m',[StartDate],Now())) The 'm' specifies month The corresponding SQL would be: SELECT...
  15. I

    A 2013 Last record used

    Try adding a date stamp Now() in the record as you leave the form. Then set the button to sort the records in descending order of date stamp.
  16. I

    Requirement to break bulk emails into smaller groups for transmission

    Thanks Paul, will explore that idea later in the day.
  17. I

    Requirement to break bulk emails into smaller groups for transmission

    I have put together a VBA sub to run Outlook.Application to send a report to selected email addresses. A Table's records contain an email addresses as well as category for grouping purposes. I use a "Create Table Query" to extract the selected email addresses from the table into a temporary...
  18. I

    Browse for a file name and place as string in text box

    Thanks, that was a useful slip -I t meant I also learned about debug today. It works well.
  19. I

    Browse for a file name and place as string in text box

    Thank you Paul That was the missing link. I struggled to find a place tying Object Libraries to specific codes. For anyone reading this in future, Ctrl-G displays the dump while in Visual Basic.
  20. I

    Browse for a file name and place as string in text box

    Thank you for responding. I get this error Method 'FileDialog' of object'_Application' failed I have searched for a solution but not successful. Does this need an object library reference?
Top Bottom