Hi everyone, I'm having an issue getting a database working, I've set up a form to enter the data but I'm having trouble getting the form to calculate GST (10% of initial value) from an initial value entered if a check box for GST required is selected and then adding the GST to the initial value to create a Total Value. If you have a look at where I've got too with it so far and the picture of how I need the data too be formatted.
Here is a link to where I'm at so far with the database:
http://www.mediafire.com/?0mb0j1kdjwg
And I have what the report needs to look like:
http://www.mediafire.com/imageview.php?quickkey=cpneb3tgscd&t
We have an older system that generates txt reports. I take these txt reports, then using Excel, I append the report headers to each record... creating a datatable. I then import this table to Access. I have not been able to figure out how to have Access perform this. In Excel, I use an "if" statement.
I really need help with this. I have a database that is quite large and is accessed through VPN. When I shrink and compact the database it goes to a respectable size. But over time everytime a report is previewed the size of the database grows. Or every access it grows to double its size in no time at all.
Any ideas... on what would make it grow and how to stop it.
Is there a way to use the find command in access in one report to search throughout the whole database. For instance, I am designing a database that in a report it shows the number identifier of an item, and the actual detailed information is located in a separate form. What I want it to do is to be able to find the detailed information from a command within the report that only has the number identifier.
I'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "
how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error
Dim CR As New CRAXDRT.Application Dim rep As CRAXDRT.Report Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ?? rep.ParameterFields(1).AddCurrentValue "Boston" rep.ParameterFields(2).AddCurrentValue "Cars" rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel" rep.ReadRecords rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work
I cannot open or view the design of any report. I have opened several dbs and all of the reports are behaving the same way, I can't do anything to a report in any of them! Earlier in the day everything worked fine and now all of the sudden it does not. Can anyone help???
I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.
Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.
On opening my database, I have a switchboard that opens up.
How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a report automatically after that.
Is is possible to copy queries, reports, modules, etc. from one database to another, and if so, how? I have some queries and reports in an inventory database I'd like to copy and use in another database without having to set them up or re-code them again.
am working on report generation on performance of my department. I need help to develop in Access. If anyone can help me in developing it? i had started with tables. If u have some spare time, please mail me at nrmarthi@hotmail.ca.
I've created a Report called "Labels". I would like to use a program mwalts gave me that searches my database and then sends out a mass email. I would like to take this program and instead of it searching the database and sending an email, have it search my database and print out the results in a report.
Can someone tell me the command lines I would need to add to the following program to do this? I would like to just take out the email parts of the code and just substitute them with the print label parts.
Thanks.
Code:'Designed by M. Walts'Important information! this code requires a reference to the Microsoft DAO object libraryOption Compare DatabaseOption ExplicitPrivate Sub cmdEmail_Click()'will hold the dynamic SQL queryDim strSQL As String'will hold the WHERE clause portion of our SQL queryDim strWHERE As String'will hold all the recipients of this messageDim strRecipients As String'the recordset we will use to get the emails of the records that match our criteriaDim rst As DAO.Recordset'if there is input in the search criteria, then we will run the query and send the e-mailIf txtSearch <> "" Then'if you have more buttons, just add mosr cases (the value of the radio button'= the Case number, so Value of the State radio button is 1, etc.)Select Case opgSearch.ValueCase 1strWHERE = "WHERE State = '" & txtSearch & "'"Case 2strWHERE = "WHERE City = '" & txtSearch & "'"Case 3strWHERE = "WHERE Denom = '" & txtSearch & "'"Case 4strWHERE = "WHERE Conference = '" & txtSearch & "'"Case 5strWHERE = "WHERE Donor = '" & txtSearch & "'"Case 6strWHERE = "WHERE MailingList = '" & txtSearch & "'"Case 7strWHERE = "WHERE YouthPastor = '" & txtSearch & "'"Case 8strWHERE = "WHERE PrayerSupport = '" & txtSearch & "'"Case 9strWHERE = "WHERE PACTTrainer = '" & txtSearch & "'"Case 10strWHERE = "WHERE PACTPartner = '" & txtSearch & "'"End SelectstrSQL = "SELECT EMail FROM tblUser " & strWHERE'run the query and get the results into the recordsetSet rst = CurrentDb.OpenRecordset(strSQL)'Loop through the recordset and add all the EMailsDo While Not rst.EOFstrRecipients = strRecipients & ";" & rst!EMailrst.MoveNextLoop'remove the first ; from the strRecipientsstrRecipients = Right(strRecipients, Len(strRecipients) - 1)MsgBox strRecipientsDoCmd.SendObject , , , , , strRecipients, txtSubject, txtBody, Falserst.CloseSet rst = NothingEnd IfEnd Sub'stops a ' entered in the field from breaking the queryPrivate Function SQLSafe(safeMe As String) As StringSQLSafe = Replace(safeMe, "'", "''")End Function
I have a multi-layered question regarding setting up an access database for fluid samples sent in by a customer.
Ideal Setup: The database would prompt me for the Sample ID number which is a unique code we give to each sample. It would then prompt me for the customer name and if given an existing customer name it would pull up all the contact information for the customer. It would then prompt me for the machine ID# that the sample came from, from which it will pull up the data from 10 previous reports and place into the current report.
I would then input the current data for the sample after analyzing it. I then have an automated control to convert the report to a .pdf file and send it via outlook. It would also be nice if the report was uploaded onto a website that the customer could access, but this is a whole different issue.
Is this setup possible with Access 03 and if so is it even remotely possible for a newbie like me to create? Additionally, what would the time investment be for a project like this for a beginner? Are there any other more effecients ways or programs to accomplish this level of automation?
I have a database that has been functioning very well for nearly a year. Suddenly today, as I attempt to open a report (very complex report takes about 2 minutes to render), the database closes before displaying the report. I have moved the db from the server to my desktop and the same problem happens. It does not matter if I try to execute the report from the switchboard or from the Report Object List.
DB is 344,940KB. I have larger db's that work fine.
I don't know where to look for a way to stop this from happening. Nothing was done to the form design between the last time it worked properly, and today.
I need help with an access 2000 multiple queries problem.
I have the following:
Table 1 = info below / table 2 = computer types / table 3 = offices 1 through 10
field 1 = name (20 employees) field 2 = computer (5 different type of computers) field 3 = office (10 different offices) field 4 = issued field 5 = not issued field 6 = stolen
On a form I have the 2 combo boxes (computer and office) to select and check boxes to select issued or not issued or stolen.
I need a report printed based on the multiple criteria query only showing the results that I ask for. For e.g. in office 5, computer IBM, issued. Print Report: lists names of all in office 5, with IBM’s, issued only! etc.
I have a database in MS SQL. The users connect to database via MS ACCES ADP applications.
Some tables (like a TV Station or Names of employees) in the database have fields that serve as the flags. If the flag has a value of one, then such a record is used in the query to create a report.
Because there are multiple users of the database, frequently happens that flags overlap. One user sets the flag to one, and second sets the flag to zero. Therefore, it often happens that the received report incorrect.
Selecting the "General" group as this involves SQL Server Stored Procedures (SP) and VBA code and Reports and and and...
Client has requested exception type reporting noting when a price in a Bill of Materials (BOM) changes.
I am thinking to solve this with the following steps:
1) EXEC SP to run "this week's" BOM reports, automated, figure out how to print to PDF or something 2) EXEC SP to run "this week vs last week" exception report. A giant nasty:
Code: SELECT cols.... FROM [xyz] LEFT JOIN [histxyz] ON [xyz].[partnumber] = [xyzhist].[partnumber] WHERE [xyz].[cola] <> [histxyz].[cola] OR [xyz].[colb] <> [histxyz].[colb] OR etc...
through each of the fieleds that are hooked up to change tracking. Run that SP once, then use that temp table to generate customized reports based on parts per product which had a change.
3) Update weekly state snapshot of all parts remembering this week's state... transfer data from [xyz] to [xyzhist], so TRUNCATE then INSERT commands.
Seems slow and monotonous, the snapshotting "shell game" aspect... perhaps I may wrap that all into a transfer SP and allow the data to stay right on the server as it moves tables.
Hi! This is Kishore, working on VB Project which is using MS-Access95 as backend. Now, i want to change the Database login Password. Could anyone guide me in this context.
Using Access's User and Group Accounts or Using a Login Form to access database?
I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.
I also saw some sites where they give an example of a Login Form and how to create one.
My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?
But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?
Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.
How would I go about creating that. Hope I made my explanation clear.
I have two database applications and they are: - the (A) application is for administration use. - the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.
The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
:confused: hi guys i'm working on a Personnel Project that get members information & data like Name , F_name , Birth date , place of birth & some other informations , but i want to add a Picture frame that show picture of every member in my form ( each record has a diffrent photo that i can select it from hard and fit it in a for example 3x4 Frame & store it in a access database . and then add that photo in a report with other datas !!! would u please help me doing that ?! thanks
I have a database that I created that uses a form to fill out information about server builds. I contains information about who built it, the IP address, server name, etc. I want to be able to create a dailog box that allows the user to input a server name to query the database and create a report based on that input. And if the user input isn't found in the database, a dialog box comes up with some sort of error message. I am still pretty new to Access, so the more detail you can give me the better. Thank a lot.
I have VBA code that switches a form to a report that works with buttons but refuses to work when first loading up the database.
Ideally I want the database to open , with a control form set as the default load form, and then this immediately loads a report, which it does, but it doesn't ever switch to it?
I use as standard: DoCmd.OpenReport "rpt_here", acViewPreview, , , acWindowNormal