Search results

Hello all, I have a question regarding how to handle missing libraries... I converted an old Access '97 database application to 2003 but it does not work on PCs that only have the 2003 version installed because of a missing library. The library in question is "Microsoft DAO 2.5/3.5...

Hello, I've created a union query - the first query has a date field that the other does not (it's supposed to be blank). So, in the one that is supposed to have a blank for that field, I wrote: "Null AS myDate". Both queries work fine on their own, in the union query however, the entire...

Hello, I've got a split db and I need for the link between the two to be: \\server\name\myBEdb.mdb instead of: S:\name\myBEdb.mdb The server name will not change - so I don't need anything dynamic. Will this need to be done via VBA and, if so, could someone point me in the right direction...

Hello, I get a field (called "range") from another database (which I have no control over) that gives me a list of numbers delimited by a comma (ie. 1,4,11). I need to query on these now and I'm not quite sure how to proceed. I didn't think it would be so bad because it's a list, but I just...

Outer join help please! - SOLVED Hello, here's the db structure on which I need to query (I didn't bother writing out the Person table): tblGroups --------- GroupID GroupName tblLevel -------- LevelID LevelDescription tblRecords ---------- PersonID GroupID LevelID By doing an outer join...

Hello, I have security set up for my application with users assigned to groups (Admins, Employee, Manager, Users). Everything was working well until I needed to add a lookup table. Only Admins and Managers can read from this table now, so my form won't load! I noticed that under "New...

Hello, In my main report, I have 2 subreports that run the exact same query (they just display different data). The query prompts the user for a year. This works great except that the user is prompted twice (because the query runs twice - once for each subreport). Does anyone have any...

Hello, I can use the TransferSpreadsheet method to get my query output into Excel - but is it possible to use a dynamic query? For example, rather than: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryMyQuery", "C:\My Documents\myQueryInExcel" Could I do something like?: Dim...

Hello all, I have a small problem with pre-loaded forms. In my switchboard form, I pre-load another form using the following code: DoCmd.OpenForm "myForm", , , , , acHidden This would work perfectly except for one thing - all of my forms have either "DoCmd.Maximize" or "DoCmd.Restore" in...

Hello, Currently, I have 3 modules each with only 1 function. I don't think that the names of the modules have any impact on the database at all so I'm just wondering if there are any pros and/or cons to having everything in 1 module? Would there be a performance difference one way or the...

Hello, I don't like to have have too many queries in my dbs, so I write nested queries whenever I can. For some reason though Access fails every time I try. It will run the query fine and even display properly in design mode after I've written it, but as soon as I try to save it an error...

Hello everyone, I'm a little stumped on something. I would like to know how many levels down something is in a hierachy. Table_Hierarchy ParentID ChildID Here are some typical entries (1 for President, 2 for Manager, 3 for Secretary) 1 2 2 3 If you follow this, 3 is a child to 2 which in...

Hello, From my front end, I link to several tables from various databases. I just need for one of those tables to be read only in case a user opens it through the database window and tries to edit it. It does however need to be editable in the original database (where the table comes from)...

Hello all, I'm not sure what I might have changed, but I cannot seem to restore or minimize my windows in an Access app after it's been maximized. The buttons just disapeer after you maximize it (see attached screen shot) - including the db window! (note though that I can still control it with...

Hello all, I have a form which displays 2 date fields in the following format (in the textboxes): mmm dd", "yyyy hh:nn AM/PM They both display the way I want - the strange stuff happens when I click in the textbox to edit the date, one remains in the same format while the other switches to...

Hello all, I have created user accounts - assigned their permissions - and then assigned users to those groups. I'm having some problems though - when I check the permissions for the groups it seems fine, but if I click on the individual user they have no permissions! Should they not inherit...

Hello everyone, I've been able to add a form to allow users to change their passwords from this thread (thanks Autoeng!) http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37534 Now I would like to create a new form that would allow one to add or delete users. I can handle...

Hello all, I've made it so that my form refreshes after any updates to any of the records on my continuous form occur. This works fine, but it was a pain to put in an after_update event for each field. Could I not have done just one? ie Private Sub current_record_after_update() me.Refresh...

Hello everyone, I have a split db in a network environment. My FE gets copied from the network and pasted into a folder within the users C drive (the method posted by Autoeng). This has worked great for everyone except for today when one of the users got a new pc. It worked the first time (a...

Hi all - I'm having one of those days where I just can't seem to get something that seems so simple. I need to run my event on a record change (when the user changes the record using the navigation buttons). Do I have to create my own navigation buttons, or is there a "On_record_change" event...