Search results

  1. A

    the grid on web forms

    I am modifying a template from MS that's the Asset Tracker and I'm having a bit of difficulty finding out how manually place my controls on the web forms. I converted all of the web forms to client forms but the background "grid" type of placeholder mat that is there is still restricting the...
  2. A

    trouble with structure

    I've been asked to design a DB for warehouse inventory and migrations being done inside server farms. But I'm having trouble visualizing what I need for relationships so I can get the detailed info. out of it. My issue is figuring out what to do with all of the child tables that stems from the...
  3. A

    reading .DB file information

    all, I see a lot of requests for this operation, but apparently .DB files are so general that sometimes it's impossible? Does anyone know of an all-encompassing program that can read files like this? I believe they come in different formats and are produced by a variety of different programs...
  4. A

    Before Update vs. Form Close

    All, I have code running behind an image on a form that is used to close it. I also have code running behind the Before_Update() event. My code behind the Before_Update() event was meant to address the user navigating to a new record via the nav bar arrow button at the bottom only. Data is...
  5. A

    deploying a password protected backend

    All, I have to do this and I believe there is VBA code to re-link tables when needed that can be found on the web. My client needs access to everything because he will move on to another developer after this, so what I thought I would do is send him a private file that has the password for the...
  6. A

    VBA manipulation of a report

    Hello all, This is an expansion of my other thread: http://www.access-programmers.co.uk/forums/showthread.php?t=253820 My database is not designed very well at all. It's fairly small, but what I need to do is ... after you search for records, on the next form there is a button for printing...
  7. A

    need to split data into 2 pages per record

    all, My records are huge, with 2 memo fields. One memo field has the complete content of journal articles, so it's quite a lot of text. What I'd like to do is, per the title, split record data into 2 report pages each with the first page holding the summary field data and the second page...
  8. A

    geometric mean

    does anyone know a couple of equivalent pieces of mathematics to get to this in Access? Here is a link that explains a little bit about it: http://timothychenallen.blogspot.com/2006/03/sql-calculating-geometric-mean-geomean.html However, I'm having a problem with summing an entire field...
  9. A

    I need some assistance for pay (small updates)

    hi all, Sorry to post this here. I know it isn't quite fair. I am unfortunately a little over-extended on my projects due to scope creep issues that were forced and I'm wondering if there is anyone here I can farm out small updates to and pay them for it? If this can belong in another forum...
  10. A

    User Level Security after ACCDB

    Hi guys, This thread explains a little bit: http://www.access-programmers.co.uk/forums/showthread.php?t=243395 How have you guys handled the fact the ULS has been discarded with the new file formats? I have a file right now that I am looking at and the ULS dialogs still show all of the...
  11. A

    can grow / can shrink anamolies between Access versions

    hi again guys, Does anyone know if the issues with these textbox properties have been fixed in any version? These things have never worked for me and I've always had to 'BS' my way through the development because I can never seem to get them to work. Does anyone know of any specific...
  12. A

    common form structures

    I like building apps that generally display data in the format presented by continuous forms. (one record per line). However, I also like providing separate forms for adding records one by one. There are so many options for this stuff (adding, deleting, editing). But I'm really into...
  13. A

    report selection hierarchy

    all, I have some requirements whereby there are many reports that are needed to be given to the employer. I had an idea the other day and I wanted to run it by you guys. The reports can be categorized in a hierarchy (like everything else in this world of course): => Type => SubType => Name...
  14. A

    transferrable controls to Sharepoint or Office 365

    all, Does anyone have a resource for this on the web anywhere? I believe a sharepoint BE with an Access FE is just a data stream isn't it? I don't think the displays are actually form objects, they're just representations and the data in the background streams to and fro. Does anyone have...
  15. A

    question about user32.dll

    all, do the functions in this lib ever change? I'm dealing with deployment environments that range from windows XP all the way up to windows 8. If I reference functions in this lib by declaring them in VBA, does anyone think there will be issues with this across that huge span of OS's? thanks.
  16. A

    using #Print to send records to CSV file

    all, I'm using this function and I'm concatenating all of the field data from the Excel spreadsheet into one string that represents a record. However, some of the field data actually *contains* commas! So my record string would look like this: value1,value,2,value3,value4 So using #Print in...
  17. A

    massive data hierarchy advice

    Hi all, I have a situation here where I'm going to be making a DB app that has a massive amount of data storage requirements, but ironically it fits perfectly into a 3-dimensional structure (e.g. - literally all 1-many relationships can be used for the entire set of tables). Here is an example...
  18. A

    I forget what sections apply to grouping and page breaks...

    all, It's been so long since I've done this, can you guys help me out here? I have a table that has invoice line items in it. Each line item has the same invoice number to it. I am creating a report, but I need to group the records by Invoice # so that, after each # (and all the line items...
  19. A

    hiding right-click menu items in office programs...

    all, In excel I'm trying to figure out how to eliminate (or hide) right-click items as they appear when you right-click a cell (or even on the worksheet itself). I believe the following folder (and key addition) in the registry is relevant to this request: CURRENT USER \ SOFTWARE \...
  20. A

    vbs and active directory

    does anyone know of a good site that offers good advice on how to research writing vbs code to interact with active directory? I'm assuming it's fairly simple but have never done it. I'm aware that AD is just a storage resource for information on a windows network, but I'm thinking there's...
Top Bottom