Not Linked to BE database at startup

I just finished splitting my database and now I am having a different issue. The front end will be used to connect to several different BE (depending on the project being worked) I have the code to make the connection as needed. My issue is that the BE will all have different names and maybe locations. When I try to load the form on the FE, Access will not even run any code in load event before it errors if it cannot find the BE it was connected to. What I want to happen is have the form load and post a msg saying that it is not connected, then allow the connection to be m

??how to?? 10 random records per user in large file

Hello, I am just starting to learn Access and know some basics. I've tried using SELECT TOP * to try to get what I need, but obviously Access is not reading my mind correctly wko I'm working with database tables that have around 200,000 rows of data pertaining to work-units completed by 70 employees in a week (column label = ENTR). The SELECT TOP * brought me back records for only one user...it was the right number of records though - 10 for emp# 45678 ;) I need to randomly select 10 records for *EACH *user-id (unique to the employee) so that I can review productivity and qu

Hyperlink to a specific page in Excel

Hi there Is it possible to set up a hyperlink to a specific page in Excel? Currently, the hyperlink is to the first page of the Excel file but I want it to link to the second page of the file. Thank you in advance for your help.

DLookUp

An AC2003 table contains journal entries. Each entry contains a date (DJ_Date), a time they woke up (DJ_Wake_Time) and a Time they went to sleep (DJ_Sleep_Time). The DJ_Date is formatted as a general date. The two times are formatted as short time in the table definitions. The table name is DailyJournal. In order to compute the total time slept I need to compute the difference between the time they went to sleep the night before and the time they woke up today. I'm using the Diff2Dates routine (I use it everywhere, it's great). The problem I'm having is with the DLookup.

car sale

I am wondering if you still have the car. If you do could you pleasesend me your number or address. Thank you. You can call me at 206 366 2810. Fedor Galenko.

How do I create a report with headers in a row?

I want a report which has a lot of information given per each day of the week. I want to far left column to print only once with the corresponding information for each day beside it. Example report: cleaning tasks to do 3/1 3/2 3/3 3/4 3/5 3/6 clean bathrooms 1 1 mop floors 2 1 vacuum bedrooms 3 vacuum living 1 wash laundry My current column report shows this: 3/1

Button on form to print report for current record

I want to put a button in my input form so it can print a report looking at only the current record I am in using2007. See names below: Input Form: CC Form Entry Unique Field: CC Number Report: Customer Complaint Form Can anyone help? thanks so much

Switchboard passwords

I have two switchboard pages. One with options for a user and one with options for an admin. On the main switchboard I have two selections: user and admin. I want to be able to attach a password to the admin selection so that when someone clicks it they will be prompted for a password and then directed to the admin switchboard.

Form - Relating two tables

Hello, I am trying to create a project progress form. The is completed twice a month. I have created a table that has the periods as follows: Report Num Period Start Period End ------------------------------------------------------ 1 01 Jan 10 15 Jan 10 2 16 Jan 10 31 Jan 10 etc.... The second table has the work items in the project: Item # Work Desc. % Total % this Period % Cumulative -------------------------------------------------------------------------------- 1

Opening hyperlinks

I have a hyperlink to a wiki that opens in my database window. I have to click the back button to return to the database. Can the wiki be opened in a seperate window?

Query Criteria IIf statement

I'm using MSAccess 2003 and this seems like a simple process, especially compared to some of the things I'm trying to do in my database. In the criteria of a query field, I am using the following IIf statement: IIf([FYAGR]>3000000,3,<4) [FYAGR] is a different field in the same query. When [FYAGR] is greater than 3,000,000, I get 3 as expected, but no matter how I word the range of numbers I'm looking for in the false part of the statement, my query returns no records. If I remove the IIf statement and place '<4' I get the correct range, but no matter the combination I can'

Filtering a form with a combo box using left function

Hi I have a table named "TblData" containing 5 field One field is named "IDProcedure" (text field) This field contains information like "M-41-25" or "P-1000" or simply "41-50" I have a form with "TblData" as records source As I want to filter the form, I create a combo box with 3 choices "Manuals"; "Procedures" and "Process" Now I have to put some code on the after update of the combo box "ChoixCat" to filter the form The only way I can manege it is using the first left character of the field "IDProcedure" So if the user select "Manuals", I want the filter to be app

Adding "IF Statement" to existing code

I am currently working with a database that is working well. However, I have discovered that I need to add an "IF Statement" to change the expression so that it adds all of the weeks service if the DepartmentName field is equal to "Reserves". This is the existing code: =DSum("[WeeksService]","Service Record Query","[EmployeeID] = " & [EmployeeID] & " And [DepartmentName] = Current_Department_Name") How do I need to change the code so that all of the weeks service will be added together if the DepartmentName is equal to "Reserves"? Thanks in advance for your help. Judy

Integrate data in real time

Hello, We have been looking for a real time data integration program. We have not found the right software yet. Basically we'll be using the tool for the migration of contacts and data in real time. Thanks for your help!

Explorer 8

Does anyone know how to remove IE 8, if theres no remove button.

a

发件人: "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> 主题: Re: PaintBall 2 日期: 2010年3月10日 9:35 On Tue, 9 Mar 2010 20:10:48 -0500, "Ben" <bgagne@live.ca> wrote: >Paintball 2 Is AWESOME!!!!!!!!!!!!!!!!!!!!!!! > >^_^ It's also completely offtopic for this Microsoft Access technical support forum. Please find a more appropriate venue. -- John W. Vinson [MVP]

Calculated field in a table

I've got a table with 10 of 15 fields calculated. I enter data into the table via a form, which does the calculations. The form works fine, but for some reason the last 4 calculated fields don't get entered into the table. Should I even have calculated fields in a table, or should they primarily be used in queries and on reports? If ok to put in tables, any idea why the last few calculated fields aren't being recorded? Then 1 out of maybe 15 records the calculated fields do get filled! The same data is input for every record. TIA -- Logo

How can I create stock emails to reply to clients?

Can anyone tell me how to do this please?

PaintBall 2

Paintball 2 Is AWESOME!!!!!!!!!!!!!!!!!!!!!!! ^_^

Query Criteria is not working

I am having an issue with the criteria of a query. I am limiting the data by a date range, an account code, and the number of loads. The date uses BETWEEN @FromDate AND @ToDate The account code uses NOT = 4125 OR NOT = 4121 The loads is > 0 With the above scenerio, I get no loads which are 0, but I still get account codes 4125 and 4121. If I put the account criteria in seperate columns, then I remove those account codes, but then I get loads that have 0. Any ideas? Cahd

General Table/Input Data Question

have a bit of a problem for a small little project i wish to finish and i am stuck on a minor detail. Basically this little project has to keep track of receipts Company Name Vat Number Date of Receipt Amount of Transaction the easy way of doing it of course is just straight input it into the table (either directly or via the use of a form to mask the entry into the table in a pretty way) I have gone the form route and well i have discovered that i have several receipts from the same company which means i have to enter the company name and Vat number over and over ag

Renumbering or inserting

Hi, I need help renumbering my records. I'm new to Access so I'll explain what I'm doing and if there is a better way please let me know. From a form the user can either choose to create a full set of tasks or a reduced set of tasks. These tasks show up on another form called "traveler". I made two tables. One table has the full tasks (80 records) and the other has the reduced tasks (30 records) But they aren't really records per se they're more like 5 word instructions that tell someone what to do. Anyway, when they click the full button I run an append query that append

Changing Form background color conditional format

I am trying to fingue out how to get the conditional format for a Form. There is a field called [Reason For Test] and I am trying to write the code so that when someone chooses "Applicant" the form page (not continuous) background color is Green, and when they choose "Allied Agency" the form page background color is blue. I would really appreciate help with this.

Auto-Increment Issue (couldn't find this one)

Windows XP Service Pack 3 Access 2007 (from Office 2007) Visual Basic 6.0 I have a table with an auto-increment column. This time of year, there is a lot of deleting and inserting going on in that table. Inserts are done through a Visual Basic program that does not touch the auto-increment field. Now and then, more so this time of year, I get a duplicate in the field and of course if fails. I found that, to fix it, I have too compact and repair the data base. Needless to say, that gets tiresome doing it multiple times in one day. Any solutions? thanx, nick

Using and "IF" statement

I am working with a database that uses the following code to sum the weeks service that an employee works in a given department: =DSum("[WeeksService]","Service Record Query","[EmployeeID]="&[EmployeeID]&"And[DepartmentName]=Current_Department_Name") The code is working fine. However, I have discovered that I need to add some type of "IF" statement so that if the Current Department Name is equal to "Reserves", that it will sum all Departments (not just the Current Department Name). Thanks in advance for your help. -- Judy

how do i get a macro/code to open a specific switchboard page

hi i have four switchboards (patient, staff, lists, accounts) with patient being default but i need to open the staff switchboard using either a macro or VBA thanks

Alternative for MS Excel VLOOKUP function in MS Access2003

I am converting several MS Excel spreadsheets into a single MS Access 2003 database for a User. The User’s original MS Excel VLOOKUP query is coded as follows: =IF(VLOOKUP(EG2,EH:EI,2,FALSE)=B2,"Good",VLOOKUP(EG2,EH:EI,2,FALSE)) New MS Access Table Name: 0301_ElectricitySupply_FeatureLine-up Field names for MS Excel and MS Access are as follows: MS Excel Cell: MS Access Field: A2 Verify Config “A2” is VLOOKUP function listed above. MS Excel Cell: MS Access Field: B2 Config No Example: B2 / Config No: MTU0301-0010 Note: This number is a

ghostscript question

I've been using GS 8.14 for several years now in a couple of MS Access apps and it's run great. I'm converting word docs to PDF's. But one of my clients ran into a small problem so I'm trying to switch to GS 8.64. But the modules that I was using in my mdb for GS 8.14 don't seem to work wiht 8.64. I changed all the code to show the right version and a copule of other little path issues have been taken care of and it runs without errors but the resultant PDF is coming out blank now. So I'm guessing that the GS code modules I got somewhere for version 8.14 won't work exactly right

Format question

I need to use the Format function in a calculated field in a non-saved query. The table field in the calculation [intSomeVal], is an integer. I'm having trouble figuring out how to get the zeroes and nulls to display as non-zero (""). Ordinarily, this format property would work #;-#;"";"" But in a Format function I can't seem to figure out how to get a zeroes and nulls to display as blank. Val(Format(intSomeVal,"#;-#;?;?")) Thanks for any suggestions.

How can i tag up a record 6 months before it expires

HI. Using Access 2000. I need a formula or qurey to flag up records whith Training Certificates that are about to Expire. I would like to know 6 months before thay expire so that i can organise new training before the expriry date. Is this possible? -- Thank you for reading my post. Hopefully you can answer my querie

Bvbnikjmjkb

Htfgljk .lt6gyhjtybhnj

How can invoices be generated from multiple queries in Access?

I am an office manager for my local synogogue. I have created an Access database to track our membership and their pledges and payments. I would like to be able to generate quartetly statements that indicates a previous balance, each pledge and payment (i.e., transaction) for the quarter and the current balance. In the past I have used Mail Merge for things like this, but this time I am having trouble embedding in a document information from multiple tables/queries. Any assistance with this task would be greatly appreciated. Thanks!

Function for UserName Group

Function for UserName Group Hello, Using Access =9203 on XP system=85 I know there are a few functions out there that will pull the windows username=85 I=92m looking for one that will also return the group (set by the sys administrator) to which the username is assigned=97should the username be assigned to a group. One of the functions that returns the username, utilizes (I believe) the mpr.dll=85maybe there=92s one for the group name (just a thought)? Thanks for any help, alex

Rounding Problems with Euros

Hi, I noticed that every time I dive, add or multiply a number in euro the answer doesn' t Maatch the euro number. Does anyone know how to eliminate this ongoing issue i'm having? Here is an example to better explain my problem: let's say I have a bottle of rum that cost 4.50€ and let's says there are 12 bottles in tha case. If I want to find out what the case cost is if I do 4.50 x 12 I would get the case cost, but when dealing with euros the final case cost once I multiply doesn't reflect the bottle cost once I divide my answer again. I would get something like 4.53 or sim

Autonumber trying to create duplicates

I use an autonumber as my primary key in my table contracts. From the form contracts users select create new record, enter the contract number and state and county and then refresh. Sometimes the error message comes up with trying to create duplicates. When I investigate the contract number which is a unique field itself there is no duplicate. If I reset the autonumber everything is fine and the user can add records with no problems. This error seems to occur randomly and I need help as it is killing productivity. Thanks

Mixing Access 2007 with 2003 and Replication

I am presently using Access 2003 and contemplating upgrading to 2007 and have a couple of questions. 1-If I keep my MDB as "2002-2003 format" can it take advantage of all the changes, in particuler "Export to PDF", I want to be able to Email directly (no more PrimoPDF)? 2-If I change my MDB to 2007 can I still replicate to the others MDB's ("2002-2003 format")? Thanks for any help.

How to access data in Access 2007 through Sharepoint

I have an Access 2007 database created and ready to use. I would like to use the Shareport as an interface and though it to access the forms (input the data) and view the reports in the Access 2007 database. Is that possible? And if yes, what is the way to do so?

'asctrls.ocx' error

I have a database created under Microsoft Office 2003 and Windows XP. Works with no problem with Office 2003 and XP. I have tried to load it on another PC with Microsoft Office 2007 and Windows 7. It will not load and locks the PC. The error message is 'Your Microsoft Office Access database or project contains a missing or broken reference to the file 'asctrls.ocx' version 1.0' As I can't load this database on the new PC, I have no idea what to do. Other databases I have transferred across work fine. Any suggestions please? thanks

vista - vba - appactivate trouble

Hi all, I have an application running on several xp, vista and 7 computers. (access versions >= a2k, db format = access 2000). This application communicates with other applications using keybd_events and appactivate On some computers running vista (not all, why why why?), AppActivate often hangs in these cases: * when you put a windows in background, and try to activate it, * when you minimize then maximize some times (1, 2, 3 times) then try to activate it. The problem can be reproduced at will on any of these computers (and the problem doesn't occur on other c

asctrls.ocx error

I have a database created under Microsoft Office 2003 and Windows XP. Works with no problem with Office 2003 and XP. I have tried to load it on another PC with Microsoft Office 2007 and Windows 7. It will not load and locks the PC. The error message is 'Your Microsoft Office Access database or project contains a missing or broken reference to the file 'asctrls.ocx' version 1.0' As I can't load this database on the new PC, I have no idea what to do. Other databases I have transferred across work fine. Any suggestions please? thanks

te llega ?

te llega ? __________ Informaci�n de ESET NOD32 Antivirus, versi�n de la base de firmas de virus 4786 (20100119) __________ ESET NOD32 Antivirus ha comprobado este mensaje. http://www.eset.com

Unable to open subforms in Access

I am working with a access database that is located on a network drive. This database is a patient history list and when i double click on the patient's name it is supposed to show me the patient history but it doesnt. I have gone to the access options and changed the trust center settings to allow all macros to run but still can not get the database to work. Any Idea's?

Importing Excel file without server access

I'm automating the process of emailing query results as an Excel file attachment to one recipeint. The recipient will complete data in the Excel file. My problem is that our company will not give this person access to our server, therefore he cannot upload his updated Excel file to one of our drives where I can then access it, import and update my table. There is nobody that he can email the file to either. I believe, however, that he'll have access to unpload a file to our company's SIFT site. Is there a way, through automation, that I can then import the file from the SIFT sit

subform option group not working

Access2003 I have a main form called fClosure (PK ProjectID) There is a subform called fClosureApproval (PK ClosureApprovalID, SK ProjectID) On fClosureApproval, I have an option group with 2 toggle buttons. see code below Select Case optApproval.Value Case 1 'Approve Closure by adding PM and date Me.ApprovedByMgr = DLookup("[ContactPMgrID]", "[t040Project]", "[ProjectID] =" & [Forms]![fClosure]![ProjectID]) Me.DateMgr = Now() Case 2 'Request Clarification by displaying pop up form Dim stDocName As String Dim stLinkCriteria As S

Iff statement to show pictures

Is it possible to use Iff statement to show pictures Actually I am trying to use tow different pictures on the form if the value is less than 0 or higher than 0 example =IIf([Text135]<0,"","Pictue B") =IIf([Text135]>0,"Pictue A","") How can I Do This so far i am unable to fix this issue Regards Aamer

How to install Provider on server

Dear Sir/Madam. I am getting this error Provider error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Actually In our page I am reading XML using ASP, Error at this line adoRS.ActiveConnection = "Provider=MSDAOSP; Data Source=MSXML2.DSOControl.2.6;" It was working fine in past but when we changed our server then this problem creates. One person saying this problem occurs due to unavailablity of provider. So please tell me what is the main reason. Please help me what to do a

MSDAOSP (MSXML2.DSOControl.2.6) in the server

Dear Sir/Madam. I am getting this error Provider error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Actually In our page I am reading XML using ASP, like adoRS.ActiveConnection = "Provider=MSDAOSP; Data Source=MSXML2.DSOControl.2.6;" It was working fine in past but when we changed our server then this problem creates. One person saying this problem occurs due to unavailablity of provider. So please tell me what is the main reason. Please help me what to do and how to do to rectify thi

Invoicing using Access

Hi I am fairly new to Access - but totally sold on the possibilities and am well on the way up the learning curve. What I need to do pretty quickly is work out how to raise an invoice - one was built for us but it doesn't seem to work :-( Rather than get the person back to re-do it, I thought it would be better to learn the process so that we can create our own in future. We are using Acess 2007 with Windows XP Pro Most of the information is in one table called Billing. We need to include: Hire of Centre (optional) + Number of people * cost per person Less deposit paid

form

---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=1abfd859-2cd0-4d4e-8724-df2e535eeefb&dg=microsoft.public.access

Merge PDF from Access

Hi I need to generate a letter in PDF with a couple of fields such as name dob etc from access. How can I achieve this? I am thinking to maybe have a word document and then fill the fields from access via automation and see if there is a way to convert this letter to PDF. Is there a better way? Many Thanks Regards