Recent content by David1234

No joy on this either. Stock_Form1 is an subform pulling in one record dependent on the stock code entered in by the user. So, if the user enters code 12-345-678 the subform will check the datasource and provide the cost price. Is it because I am adding a field from the main form with a...

Hi Peter, Thanks for the reply, the error has persisted. Is it something in the set up i'm doing wrong? I have the field, drop it onto the form the results are needed on. I then enter the properties of the form and then enter the code you suggested. David

Hi, I'm trying to multiply two values, one from the main form, one from the subform into a total on the main form. I've set the expression in the control source as this.. [RH_TOTAL_CREDIT1]=([RH_QTY_CREDIT1]*[Forms]![Stock_Form1]![STK_BASEPRICE]) Is that completely wrong!!?

Hi, Sorry for the title - Not really sure of the name of the issue we're having :banghead:. I have two forms made up from tables from the server 1) Market Categories, 2) Market Countries. The object of the database is to categorise products from another table (Stock) based on tick boxes...

I knew it was something basic like that. I've gone back to two databases i've made before and now i've got a clear head it's all so clear that's what i've done before!!

Hi All, I've been making a database, and for the life of me I can't remember something that I used to consider slightly basic :banghead: I've got two forms, one header, one detail. When a user enters a record on the header it gives the ID (PK) field a No, when the detail is entered it...

Hi, I need some help with VB as I haven't got a clue on how to use it :) I have made a database which deals with customer returns, the difficulty is the final report stage, and unfortunately the requirements of the report have forced me to use crystal, rather than acess reports. I have...

Any news on this?

Hi All, I have a problem with the way my report is displaying info. I have it creating a sheet based on records in my main/subform combo form. The issue I have is as follows; I have a primary number, sourced off the main form. And a detail number, sourced off the subform e.g 1A,B,C,D etc...

Hi, This is probably a basic question, but it's confusing me!:confused: I'm creating a database for my company, the main form is working a treat, and is in the process of being tested. However for other parts they only want to see certain info on certain forms, pulled from the main form. Eg...

I'm working on the live version, users are working on v2, i'm on v2.1 I haven't split the database, within the company there are several databases - These have been consilated into a central one via switchboard. This is the only new one that has been added manually - The strange thing is that...

Hi All, I've reached the point now where i'm releasing my database to end users to use. Cosmetic changes were requested by the users, so i've attempted to do this - However, when the changes are made and attempted to be saved, the system goes through the normal process of confirming what to...

Tried this action, same result! :(

It may be that there are no records to show, try adding a test record?

Any offers? :)