Hi all,
Using Access 97 :( to create a fairly simple database for a couple of users.
When setting up a report using the wizard, I am given an error message of "No Current record" when I try and Finish the wizard.
I have re-installed Access 97 - which I thought would have most definatly fixed the problem - but doesn't seem to have done the trick.
Any thought are welcome?
Thanks, Neil
Howdy All!!! I am receiving the below error message:
"You have chosen fields from record sources which the wizzard can't connect. You may have chosen fields from a table and a form a query based on that table. If so, try choosing fields from onluy the table or only the querry."
OK here is what is going on... I have a table that is linked to a *.txt file. This *.txt file comes from our AS400 and is the root of all my information. It has 2 pieces of information in it that I need to seperate out and then eventually join back together. It is a space delimited file. The 2 pieces of information are:
1) Header (Dates, Vessell, and Container information)
2) Body (Product information and qty of each Container)
The mapping looks like this:
Header='ISPDD'
1- A Record Name = mid(1,5) [Ref. Example:ISPDD]
2- Unique Key = mid(6,7) [Ref. Example:0000001]
3- Container Number = mid(13,10) [Ref. Example:MK03000001]
4-Arrival Date = mid(23,8) [Ref. Example:06092004]
Body='ISPDT'
1- A Record Name = mid(1,5) [Ref. Example:ISPDT]
2- Unique Key = mid(6,7) [Ref. Example:0000001]
3- A item code = mid(13,6) [Ref. Example:007529]
4- A item color = mid(19,3) [Ref. Example:015]
5- Item Qty = mid(22,6) [Ref. Example:111111]
What I did is wrote 2 query's. One that looked at the *.txt file and produced results on [Like "ISPDD*"] to give me just the HEADER information. I then added the criteria from the space delimited mapping above. I did the same to pull out just the BODY information, again adding the criteria to the query from the space delimited mapping above.
Now that I have the two pieces of information, I want to run a report and combind the 2 together in a more reader friendly format. In doing so I received the error message above.
I then tried having the query's create a new table after they run (one Header Table and one Body Table). Once that completed I created a relationship between the 'UniqueKey Header' and 'UniqueKey Body'. This actually worked but, when I receive a new *.txt file and run the query it gives me read only/cannot delete files because of relationships. Needless to say I am in a bind. Hopefully I shared enough detail to help me with my problem. Many thanks in advance for the help. One other piece of info, This *.txt file can contain many headers and boddy information. I have received one that had at least 10 different Unique keys that had to be linked together.
Best Regards
Mike
I use the switchboard wizard to set up a switchboard. At the moment my main switchboard has 3 items and they are all set to 'open form in add mode' and they all point to the same form at the moment (which does exist).
When I try to go to form view of the switchboard I get the error 'The control name label1 is misspelled or refers to a control that doesn't exist'. Behind it I can see the form in form view and I can see there are the 3 menu items I would expect but when I close the error dialogue and the following 'close macros' dialogue' it goes back to design view. In design view I can only see one menu item (which seems to be a text box rather than a label) instead of 3. I changed it to a label but it didn't work.
When I try to use form/report wizard, I click on New, Form Wizard. Then I got form where I should pick fields for my form/report. But I have no one field on left side. Above I select Table but haven't any available field. I use Windows XP and Office 2003. Can anyone help me?
Thank you
Hey can I transfer data into a report wizard, to have the wizard use that data instead of the data in a table or query?? This data would come from a form.
View 14 Replies View RelatedI know there is a Access Guru out there that could do this in a milisecond, but, this one has been kickin my backside all week...
I need to know how to create a shortcut button in a form to bring up the "Report Wizard" feature. Then after that button is created, I would like to be able to hide the structure of my database so that all the users can see is the switchboard. PLEASE give me some insight here if you can, the first correct reply gets free fries with thier next order...
I'm working on a db for work. On my Nav form, I have two tabs- each tab has cmd btns that open up different search or data entry forms. I also have a few reports that can be opened based on a query I created.
The last thing I want to add is a control/button that opens the query wizard so the user doesn't have to navigate to the "Create" tab of access. The reason behind this is that one user may not know how/where to find the query/report wizard.
Is there some VBA code or Macro I can create to add this functionality to a button ("Create New Report" or "Create New Query".)
I'm using Access 2010.
I am trying to generate a report from a select query using the report wizard. The wizard is showing the error of subscript of out range. What is the reason and how can be rectified?
View 4 Replies View RelatedI am looking to call two different queries from report wizard to produce report. Getting error message what to do in this situation as both queries are important as i have to pick all records from query A and just one record from query B any other option to get this in report.
View 4 Replies View RelatedI have recently changed computers from a WindowsNT to and XP. When using the NT machine, I am able to print my Access report. However, when I hook up the XP machine and request a report from one specific database, I get the following message....this message also comes up if I try to open print preview or page setup.
"There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable."
I don't think it is a printer error as the error is occurring in this one database. I have successfully printed a test page and can open up other Access databases and print. I also tried converting the database to the 2002 format....but that did not make a difference either. There must be a setting in the database that is causing the error.....
Does anyone have any suggestions???
I using excel 2010 and access 2010. I have VBA script runtime error 3011 when running script. It has problem finding access report. First I was passing in as variable with the name. Then I used a script to pull in the report name from access and it is still failing with same error.
Code is shown below.
Private Sub Command29_Click()
Dim reportname As String
Dim theFilePath As String, FilePath As String, tempStr As String
' reportname = Me.My_DBTableName
[Code] ....
I'm just after getting my web site designed and I want upsize my present database which is MS Access to a MSSQL server can anyone help? I'm totally new to databases so I need step by step help!
View 1 Replies View RelatedI have been having this issue with two different
versions of Access, firstly XP and now 2003.
The issue is every time I open a blank database, and
click on the "create using wizard" option, access crashes
while trying to set up the wizard. When I view the
dump rep, it all seems to point to msaccess.exe.
AppName: msaccess.exe AppVer: 11.0.5614.0 AppStamp:3f3c8e3c
ModName: msaccess.exe ModVer: 11.0.5614.0 ModStamp:3f3c8e3c
fDebug: 0 Offset: 000ef3ba
I have uninstalled and re-installed Office onto
different drives etc, but still no joy.
Does anyone have any ideas?
Thanks
Richard.
I am new to access. When I try to create a control with control wizard, it advises that it will embed a macro that will not run nor be editable in Access 2003 or prior...
What do I have to do to get a control placed that CAN be run by those...? I do not know how to write code, and am really just feeling my way thru this...thus far unsuccessfully, I might add. More on that in the Forms forum...
This is just one of a billion questions I am slowly exploring.
Thanks for any assistance.:o
Hi,
I have just started to use the Access 2003 Package Wizard and I am having big problems, my problem is that any Access App deployed at work is installed under C:MIS, but in there wizdom!!! MS have decided not to allow you to have anything but what they think you should have as the default install location.
I have even gone into the source code and found where the default locations are, but the problem is that you have to add the entry to both a table and an XML file, the table is easy, but trying to find where and what I need to add to the xml, so far has turned out to be impossible.
Can anyone help, or is the best solution going to be to use a third party installer.
Thanks,
Gavin,
Hi,
I am trying to create some labels, I go through the wizard, and when it comes to selecting the field's from the "Available Fields" the address field is not there, everything else is. I have tried all sorts, how do I get the address field to appear in this list, so that I can choose it.:mad:
Thanks in advance..
Good morning all,
i have a feeling this could be a simple yes or no answer,, at the moment i am using the 'Import Data Wizard' to pick-up an excel file that is up-dated on a daily basis, this file always sits in the same directory and always has the same file name, ideally i would like to have an action button that draws the data in without having to use the wizard each time,, does anyone know if this is achieveable? if so, anyhelp would be much appreciated.
as always, many thanks
Hi Guys, I have 2 machines both running MS Access 2003 with Office SP2 installed. From one machine i can access a report and print off fine. However from the second machine i receive a #Error? in certain fields of the report. Maybe someone could help me as to why this is!?
Thanks
Does the MS Access Report support Hide/Show specific fields according to parameters or even by click?
View 3 Replies View RelatedI'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 have a report with an if then statement for a checkbox.
If checkbox is true...etc versus if checkbox is false...etc
When there isn't a record that has this checkbox checked, I get the error
"You entered an expression that has no value." (Runtime error 2427) How can I ignore this error
when the record doesn't apply to the criteria?
I have a report that is linked to a query... lets say my query returns no records the report comes up with a whole bunch of #Errors on it. How do i prevent this from happening?
thanks
Green
I have a database that keeps track of street light inspections.
There is a form with inspection info and a subform with any faults found - Works Fine
There is a report with the same information - Works Fine'ish
The report allways used to work fine but for no apparent reason it previews fine but when printing I get the following message and the subreport information does not print (although if I open the sub report seperately it prints fine).
'This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.'
I am banging my head against the wall with this one. It used to print fine and I have made no changes, apart from data. Have tried compact/repair to no avail.
Could someone please point me in the right direction, my head is hurting...
I am making a payment data base and table structure is like this:
ProjectNo
OrderNo
OrderDate
InvoiceNo
InvoiceDate
InvoiceAmount
ChequeNo
ChequeDate
ChequeAmount
1st thing is to be done is data input till Invoice Amount and then on due dates payments are released thru cheques. Sometimes payments are not one to one, means there can be 3 part payments for one invoice. So when we take the balance payment due, we get errror. Report shows total invoice amount 3 times, because details have three fields. Means like this:
Overall Supplier Invoice Payment Status For The Supplier Name - True Fab Engineers Private
Limited
InvoiceNoDateAmountPaymentDateChequeNoChequeDateChequeAmou
Supplier NameTrue Fab Engineers Private Limited
ORDER NO. P-158/B/10848 DATED 12-Apr-07
5413-Apr-072,714.0012-Jun-0752363106-Jun-072,714.00
12-Jun-0700.00
5723-Apr-074,154.0022-Jun-0752363106-Jun-074,154.00
22-Jun-0700.00
TOTAL PAYMENT DUE:13,736.00TOTAL PAYMENT MADE:6,868.00
You can see that total amount due is just double of actual. Beacuase of this all accounting is going waste.
Please help. Thanks in advance.
Just a quick one.
I'm not usre how to handle the error when cancelling a report. so when I hit a control to bring up a report and say I cancel it before I put in any parameters for example I get the dialog box " runtime error" "OpenReport action was cancelled" etc.
Could anyone help me on how to handle this with VBA so that it's at least a more user friendly dialog box?
thanks
I want to create a report using the data currently held in a form. I found this bit of code somewhere:
DoCmd.OpenReport "report", acViewPreview, , "[job number] = " & txtFilter.Value
txtFilter is the name of textbox containing the data I want for the report. This works if in the table for txtFilter's data the field is set to a number. But if I set this field to text it comes up with a data type mismatch error. How do I solve this? (sorry new to access and vba). The reason I want to set it as a text field is so that I can limit the number of characters entered.
Thanks
Chris