Search results

Hi This may be easy but i have had a look at the Access help page and can not find any suggestions to my question i am trying to do a query where i want the query to check for any changes in the last 30 days Access Help expressions Between #2/2/93# And #12/1/93# this is the help i have found...

thank you very much Mile-O-Phile i have managed to get it to work very greatful

Hi many thanks for the advice but what do you mean by recordset. i dont understand how this effect it. also regarding the code what do i type in for the VarMyCriteria. If DCount("MyField", "MyTable", "MyOtherField = " & varMyCriteria) = 0 Then MsgBox "There is nothing to show."...

Hi i have a form where if there is no data i can not exit the form as it is testing some other textboxes for error. I wanted to aks if anyone knew of a way of making a form not open up if it has no data. Many thanks in advance kabir

yeah sorry i mean resolution

loading a form Hi does anyone know if there is a way of making a form load according to the screen size i.e. if the computer was 15inch then the form would open up in full and if the screen was a 17inch it would also open up in full Many thanks in advance kabir

Hi Mile-O-Phile I am intrested in knowing how you add your pictures to fields and make then change with different items/employees thanks

cheers both of you for the last two posts much appreciated thanks

hi thaks for your reply, i have tried to use the northwind sample database but somehow i have managed to make it stop showing the picture with all the emplpyess. Do you know how i can reinstall the northwind database. Also do you know if you can use other imgae files other than bmp pictures...

Hi just wanted to ask anyone if they knew if it was easy to make a form where a bound picture is linked to seperate items i.e. employess with pictures of them Also can you use any image files or just BMP files many thanks

Hi i have a report which has a textbox which shows outstanding orders using the following code =[quantity ordered]-Sum([qty delivered]-[qty rejected]) however if there no qty delivered/qty rejected is there anyway i can have the textbox showing the quantity ordered value. at present if there...

Hi many thanks for your help but do you know how you would do a calcualtion which includes a subform. here are the cacluations i am trying to do. I have added a attachment-this shows the two tables i am trying to calcualte I am trying to do a calcualtion where i can total the amount of items...

Hi i have been told that you can do calcualtions using queries. Does anyone know how to do this as this is new to me. I have always done calcualtions using forms/reports many thanks

Hi I have a textbox which is only used on the form, and is used so it can give users a visualise of how many items of one order have arrived. However I thought since this textbox can show how many items have arrived i could use this textbox to make the order complete checkbox set to yes if all...

Hello the check box does have other significiant as it will be used on a report. If a check box is not ticked this will mean it is still an outstanding order. This is linked to a query which is linked to a report If you know what i mean many thanks in advance

Hi i have been using the following code to make a check box tick it self . however it does not seem to work here is the code i am using, it is basically if the textbox(text19) which is calculated via other textboxes is set to 0 then the checkbox will tick it self to state the order has been...

Hi Paul this might sound but i thought u couldnt do calculations on queries. if so how would you do it thanks

Hi i am trying to do a report for orders that are less than 1. The textbox that does the calculation does not belong to a table. it is purely for the report. I have added the textbox to the report for other reasons. Does anyone know how i would need to write some code for the report to only...

hi many thanks for your help, it works now however i have another problem very similar to the previous one. Except this updating requires me to update a table while i have a form open which relates back to the table. i have two forms one which is used for editting orders however this form can...

Hi i am doing a database where user select items from a list, however when they are selecting an item (partID) from the tenderlink (table). some users may need to add new part ID. So i have created a button which opens up another form thus allowing users to add a new item. Once saved the user...