Search results

Yes it is in the control source. I am not the creator of the db in question so cannot comment regarding the calculation.

Hi all, I have a form which has a few calculations on which are: TotalPrice - =Nz([Quantity])*([UnitPrice]) Then at the bottom to calculate it all: =IIf(Sum([Quantity]*[UnitPrice])=0,0,Sum([Quantity]*[UnitPrice])) This has been working perfectly fine however the TotalPrice is no longer...

Many thanks to missinglinq for trying to help, i have this working now, did have something to do with names. I was saving the names in the properties box however kept deferring back to the original but all is now working so thank you.

Hi,all my names seem to match, i have included a few more screen shots to see if this will help further.

Hi everyone, I want a search box on my db that will locate data from certain fields within my database. Today i came across the posting by John Big Booty with the above title and what he has done is exactly what i require. Now i have followed all instructions to the letter however i keep...

Hi everyone, Im hoping to start an accounts database which will all be based in a datasheet view. When our accounts need to be filed im wondering if it would be possible to export all the data into a csv (excel) file? Many thanks

Hi, All i did was add another field in to the relevant table in the be and added the field to the form in the front end. Now i have made the adjustements i need to spit it again and redistribute to the users. When i added the field to the be and viewed the fe field list the new field was...

Hi all, Not sure where i am going wrong. I needed to make some adjustements to my db, so i used the database utilities and linked table manager, selected "always prompt for new location" and then selected the be. I made the adjustments and now have tried to split again, when i use the...

Hi, thanks for your advise, the form is set to update on open. I dont really understand the problem as its never happened before.

Hi Everyone, My db has worked fine for well over a year and a half, today i am getting this error "Error 28 Out of Stack Space" if i hit debug it takes me to part of my code, i did not code the db and no nothing about it, are you able to help please? Highlighted in pink is the code error...

I use my access db for work purposes and we have two companies that operate the same type of business so we only require the one db. We also use screen popping so the customers telephone number is recognised when dialling in and the database will open of that particular customer, in order to...

Well i am hoping that it finds the records that have less than 45 days remaining and possibly says the company name or contact i.d

Tbh i have been instructed to complete it this way rather than with a query, but i cannot seem to get it to work.

Hi everyone, You will shortly be able to tell that i have never done this before. When i open my db it is set to open my start up form, from their the only option is to go to the contacts page, however before it does that i am trying to get it to check my form called Network and if the...

Does anyone have any ideas?

I am probably wrong but i think i am getting the Enter Parameter Value because there is nothing in the EndDate field. Not all records will have this information entered but the end result i am looking for is once "CLIStartDate" has had a date entered and "Duration" has an amount of months...

Hi All, I thought i has sussed this myself but unfortunately not and again need some advise. I have a field called EndDate which has the following control source - =DateAdd("m",[Duration],[CLIStartDate]) I have a form called "Network" which has the following OnLoad event - Private Sub...

I have it working now, thank you for your help.

I understand that part. The problem i have now is the coding, on the attached DB the code is written so if a box is empty to produce the records, i also no how i will view the records, from the code If DCount("[EventID]", "[TBL_JobDates]", "[actdate] < Date()-3 And isnull([rcvddate])") >= 1...

I want it to execute exactly as the db i attached, on startup the attached finds any records which does not have a date in the documents received box and displays them. I need to change it so that it displays any records has a date in the "EndDate" box and it is 45 days prior.