Recent content by wizz_darlo

I have only one table with all the data in it. Therefore I have not set any relationships! :S

I know it seems as though I'm trying to go against you Colin, but everything you're saying is really good, my only problem is doing it. I think if we look back to my original problem it's clear that I'm a bit of a novice! I don't really understand the whole Criteria stuff in a query. Is there...

I don't want them to know what the AutoNumber is, like you said, the Autonumber is there simply as a reference. It has done it's job perfectly in allowing me to call up each record for each system number. I just wondered if it could now be used as the unique identifier to then call up a report...

It was all working cool with the button I had on the form to view the report just with one slight glitch. Is there no way that this can be easily adapted to accommodate the addition of the Auto Number? The end user of this database will know a lot less about access than I do, so a button with a...

Any chance you could be slightly more explicit in detail. I'm sorry but I do admit I'm crap with this whole thing. I think my report is based on the same table that my form is based on.

I guessed that I should change it from being defined as a string to an integer?! The only problem is my skills at re-coding leave something to be desired! I thought it would be as simple as this... Private Sub Command63_Click() Dim strReportName As String Dim strCriteria As Integer...

Seeing as you're being very helpful Colin I was hoping you might be able to suggest why something else is happening now... A while ago I spent a long time trying to figure out how to code a button to show an Access Report based on a single record. The wizard's button only outputted all the...

Colin, I figured out what I think you mean...! My numbering system didn't need to change, but the way I referenced the numbers did in my form. I added an autonumber field on my table and now the combo box looks up the autonumber field and displays the relevant system and report. I made the...

I'm not sure how to use an AutoNumber ID system. The numbering system I'm using is important as it is set to Ministry of Defence standards. The system number relates to a ship's system and the report number relates to part 01, 02 or 03 etc of that system. Will much of this have to change if i...

Thanks v. much for your reply Colin. Appreciate you trying to help me out! Unfortunately I'm still not having much luck. If I take out the If statement then nothing at all happens. I select a record from the combo box but that record isn't displayed on the form. So I tried the second way and it...

The user does not necessarily know which report they will need to look at however the report number is unique for each system, like i said 3243 01, 3243 02, 3243 03. The problem arises because they need to be able to view the other reports if they want to. So if they click on 3243 01 and...

Hi, I have one combo box on a form which I have set to lookup values on the form and display the details. I have the combo box to read the values from a table tblCommReport. The fields which I need to lookup are system number and report number. The problem comes up because there can be more...

Hi all. Benn looking through other posts and have found some things which look quite similar but nothing which answers the question simply enough for my standard! Basically I have a form with 5 fields...Number, Name, Location, Date and Owner. All fields are locked apart from Location and Date...

Thankyou for your reply, However as I mentioned above, I have no VB skills so as such do not know where to enter this slice of code!! If you could advise on this it would be a great help. Many Thanks

Hi guys, I know that there are a few posts on topics similar to this but because of my serious limitation of having no skill with VB code I can't tailor the replies to suit my needs. Here's my problem... I have a form which is used to raise reports and then send them out. I have figured out how...