Search results

We just upgraded to Office 2007 and are experiencing very slow access performance. This microsoft article addresses the problem: http://support.microsoft.com/kb/275085 It won't let me change Subdatasheet Name property to [NONE]. Even if I am able to change it, will this affect my table...

I tried searching to see if anyone else had this problem but couldn't find anything. One of the tables in my database has 24 rows with #### filling up all of the fields. I've tried compacting/repairing, deleting the rows and adding them back in from a good table but nothing seems to work...

Some of the computers that I have loaded Office2003 have a missing reference. The missing reference is Microsoft Office XP Web Components. I have gone in to try to set this reference but it is not there on some computers. Is this a library that I need? Why would it be on some and not others...

My computer was just upgraded to Office 2003 but not everyone in the office is upgraded yet. Only the people upgraded can use my db now. What is the best way to have them use the db until we get them all upgraded? I searched the forum and found some links and tried to set some references...

Can anyone tell me, please, why my DLookup doesn't work using the on Click of my control button? My control is on a form that is opened from a subform. This is the code I put in my form's code: If (DLookup("[drivingHolidays]", "T_miscDates", "[dateDate] = " & Me.lboDateDate)) = True Then...

Hi I have this module that Mile-O-Phile helped me with and it works great. I have made a couple of changes so that it not only skips over Sundays, but should skip over drivingHolidays. It's doesn't seem to be recognizing driving holidays. stringDriving field should be changing as dteTemp1...

I'm not sure exactly where to start on this one. I've searched previous threads and haven't found anything that seemed like it would really help. I need to calculate a LoadDate from a DeliveryDate based on the number of days associated with that State that it is to be delivered to. Each of...

I have a query based on 2 tables. Table A has loadDates. Table B has loadDateChanges(every time a loadDate changes in Table A, Table B generates a new record traclomg the change). I have a yes/no field in table B called "update" that automatically updates every night all records that are...

I am trying to view information from a query field on a form that is bound by another query so I am trying to use DLookUp. The form with the field is F-MainEntry. The query that is not bound to the form is Q-PURCHEXPORT2 and the field is STEEL. My DLookUp looks like this and is not working...

I was wondering if anyone knew where I could get some help with linking SQL tables with Access. We have a program in SQL that I know very little about but there are is a lot of information in those tables that I could use in my Access db. Is there a good book or website with this information?

I have a field called LoadDate that changes very often. I want to track every time this changes. I want to know each date it changes and what the new date was, also knowing all the previous date changes. I thought about making a new table to track these changes. Could I get this new table...

I have made a query that one of my criteria is a date field. When I run my query that criteria doesn't work right. If I put "Is Not Null" it gets all of them, but if I put a specific date as the criteria or Now() then it pulls up nothing when I know that date is there. That field's date is...

I have setup user level security on my database and now I want to use that same workgroup to secure some other db's. I am not totally sure how to do this. This is what I have done so far: 1) Set up a shortcut on my desktop (will do this on everyone's when it works) targeting the workgroup I...

I have a form that has 3 subforms. Each subform is invisible until you select BLDG, CNPY, or CRWH from the textPLMNTYPE field. The field that links the form and subforms is the PLMNO field. I am having a problem with the PLMNO changing in the main and subform depending on what is chosen in...

I am trying write some code to print some reports, but only those that have data in them. I have used DLookup before but that doesn't seem to work this time. I have also been trying to use the On no data event on my report. What code would I write in that ?

All of a sudden today I started getting Microsoft errors on my database. Only entry was going on, all day long and then all of a sudden errors. My tables and front end are separated. But my tables are in an unrecognized database now. Everytime I try to compact and repair I get the Microsoft...

I am trying to update several records on a form at one time. My form shows in continuous view so that you can see all of the records on the screen at once. I am trying to update all of the PCODE fields at once with a control button. Can't I use some kind of loop? I've tried several ways but...

My query has multiple and/or criteria. The first row in my query has several fields based on fields on a form. The second line has all of the same except the last 2 fields. I want the last 2 fields to check if the field on the form is Null. If the field is Null then I don't want Criteria in...

I have a report with a lot of criteria and shading. I have 3 fields (INSTALLER, SJSCITYSTATE, and DELIVERYDATE)on one line that can shrink. The shrinking part is working fine. But I have 2 lines on the side that are visible or not depending on whether all 3 fields have something in them...

I am trying to open a form based on what is entered in another form. There are 3 forms involved: main form (draftingschedule), sub form(subdrafting), another subform(subdrafting-id). I want subdrafting-id to open based on what is chosen in subdrafting. Drafting Schedule and subdrafting are...