Search results

Hi - My work computer has just been migrated to a new network and as such path to my desktop has changed because may network login name has changed. That said, I have an access database on my desktop (dev environment) and now that the path has changed the link between my front end and the DB...

Hi - I have a report that has a subreport embeded in it. There is a work order field in the main report and in the sub report, so they are my master and child links. The main report list costs associated to work orders related to vender invoices, where as the subreport list costs...

Hi - How do I use Crystal XI to connect to a secure Access DB using the .mdw file? I know how to use access to connect to it obviously, but can't figure out how to do it with Crystal. Thanks!

Hi - Recently a user asked me to delete a record from our database (through the back end, the database is split and password protected) which I've done many times with no problems. However this time, the result is a record that has #DELETE written in each field of the record and I am not able...

Hi - I've created a form to manage the passing of paramaters onto a report. I've got three comboboxes on the form: Customer # Sector (Enterprise, Public or Carrier) Region (Cities) These comboboxes are tied to tables and then selections are then passed into the query as paramaters. Also...

Hi - I tested the following code and it works great. Original Term: IIf([Contract Not Expired]=0 And [Contract Details]![Renewal Term]="Original Term" And DateDiff("d",Date(),DateAdd("m",[Contract Details]![Term],[Service Details]![End Date]))>0,DateDiff("d",Date(),DateAdd("m",[Contract...

Hello All - I've created a contract management database. We have several people logging our contracts into it right now, once a contract is entered the data is verified by a 2nd person. There is a "Status" field in the database that is either "Pending" or "Verified". Once the 2nd person...

Hi All - I've created a contract management database, which is working great. Now I'm in the process of creating reports and need help with something. I need to calculate the remaining term of contracts (in months). Assuming each contract is a 3 year term, and there are only 2 renewal...

Hi - I have two problems with my report: 1 - My report has a subreport, which has a subreport. On the "grandchild" I have subtotals, how do I add a total amount on the report footer (footer of main report)? 2 - My report is a little too wide to be printed on letter sized paper. I can't make...

Hi All - I've got a main form, which has a subform. This subform has a subform and that subform has a subform. i had it all working perfectly, however I must have messed something up because now when I enter data into the form (the parent and each of the children) it works I can save it, if I...

Hi All - I keep getting a Run-Time Error 3033 when I try to run the following code for a certain Group (DB has user permisssions) it works for me as I am admin. the error occurs on the bolded line. I checked the permissions for this group and they have "Open/Run" permissions for it...

Hi All - I've got a main form, which has a subform. This subform has a subform and that subform has a subform. i had it all working perfectly, however I must have messed something up because now when I enter data into the form (the parent and each of the children) it works I can save it, if I...

Hi All - I secured my database with the wizard a few days ago then I split the db. The permission and logins were working for both the front and back end perfectly, but when I tried to open an access file that wasn't supposed to be protected it was asking me for a password. So I accessed the...

Hi - I recently secured a new database, this new database is working great, however, for some reason now when I try to open other access files that are NOT password protected and have No security features associated to them I'm being asked to enter a password. Why is this happening? I tried...

Hi - I have a main form with a subform which has a subform in it. I'd like to make so a user cannot enter data into a child form without completing the parent form first. How would I go about doing this? Thanks.

Hi - I've just gone through the User Security Wizard in Access 2007 and it seems to work well; however I have a couple other concers. Can I disable the ribbon and remove the objects navigator on the right hand side for certain users? I know they need to add data to the tables but I want to...

Hi - I've got a lookup on a form that pulls data from multiple fields and auto-populates multiple fields on my form, but access is not going to the proper record in the table it is just displaying the info on the form so the form is always saying it's on record 1 even though the data it just...

Hi - I have a form that contains contract details from a service details table, and I have a separate table that contains a Product Catalogue. What I'm trying to do is use a lookup to populate the product item # and product item description from the product catalogue table. On the form I...