Search results

Thanks, after posting this i made a back up file and just started experimenting. Ive set all my forms to pop up as Ive programmed by access to now hide behind my Main Switchboard (custom form with buttons which set macros automatically depending on the command i set, which helps alot!) Taking...

Hi, Just after a point in the right direction. Im looking to design and create a user interface for my database. Preferably hiding the standard access interface and upon opening the database have a pop up form with buttons to direct users to forms queries and the nice helpful stuff I made the...

(might be me but i cant access the report once the file is opened in access) If your totals box works but you just wish to change its position its simple really; right click the totals box>hover over LAYOUT and click remove. You are then free to move the box anywhere on the report. If this...

Finally getting round to testing the pricing function within my database. For reference is there a way i can use the Supplier ID and Material ID but make it so the visible value is the names instead of numbers, simply for my ease of use? SOLVED

Im really bad with the expression builder. The wizard is my friend and its the only time things usually work. But opening the wizard for an existing look up is proving impossible. Ive made a quick fix for now but it isnt ideal to be honest.

Not sure why it does it, just know how to skate around the problem rather than solve it Theres only two ways ive been told how to do it. Heres a link to the solution made in my thread: Or add the Fields; Title, First Name, Last Name as 'existing field' in the form. When the ID is shown it...

The way i got around this is to add the field to the report as an existing field. I had the same problem actually and managed to swindle it by adding a field instead of changing any existing ones within the form. Ok so ill try to explain what I did and hopefully that works. In your form where...

Hi, My database is slowly coming together. For the final part of this phase i would like to create a shortcut on each users desktop which runs a summary report of information within my database. I have criteria set so upon opening the report the user is asked for which address they wish to...

Im unsure whether i can help you as Im not exactly a wizard but could you explain your problem again and ill try, just dont understand what your trying to do. Are you just trying to collect your inputted data onto a report 'JobSheet'?

Could someone help as to how i would go about changing my existing look up column. Im hitting a brick wall, had a look online but cant seem to get any where without deleting the existing one and re-doing it with the additional field.

Thanks very much. I have a combobox for the ContractNo set up already so i will edit that to show the address. Text box explanation will help in the future to now i know i can use this function to show data that should be DISPLAY-ONLY rather that input and display. Thanks again, Great help!

In my form (source tblJobs) i input a contract number from tblContracts. but i would also like it to show the contract address when the contract number is entered. Both fields belong to tblContracts but i only wish to enter the contract number, the address will just be used as a reference as it...

So in my database i have a field for Tonnage (quantity) I need for example to input 38.60 or 37.89 so my values must have 2 decimal places, ive searched and found changing my field type to double or decimal should solve the 'numbers rounding up/down' but access will not let me change the data...

Please don't refer to me as a leech, its just plain rudeness on your part. A user was present so the question was asked. If i was wrong to do that then THIS reply would of sufficed: No need to get insulting towards new members :rolleyes: and to just correct your point: If someone would...

Thanks for the great advice. I did some deeper research and managed to get hold of an order management template, this is designed exactly how you describe. Ive already attempted to build the base system about 3 times, and scrapped all attempts as i did not like how i had arranged my information...

I have an order table. Each Job has 1-3 types of material ordered. Can i used a multivalue look up box or would i have to create 2 additional fields: Material1 Material2 Material3 Each material could be ordered from a different supplier also so the same rule would have to spply to...

I do this constantly, had me stumped the first time. Now its just an inconvenience :banghead:

I would've suggested the same thing. I always tend to find if one office program doesn't have a function for what im trying to do I would transfer to another program which does offer the function. :banghead:

This is what I mean by jumping ahead of myself, I think im trying to include information that doesn't NEED to be there because im thinking ahead, hoping tables will show relevant information instead of using queries and reports. Unfortunately ill have to pop round the forums and make a few more...

Im half way through my database at this point but Im stuck because two or more tables will have identical data, im trying to avoid this, but im unsure how to include data from one table to another without creating duplicate data. (would this only be done using lookup columns, want to try and...