Search results

UPDATE problemy left join s_modul on problemy.modul=s_modul.modul SET problemy.modul = nz(s_modul.modul,-1) You could try something like this.. but no guarentees. I think its because it thinks you are referring to the table which you are updating which may change the link and thus go into...

An unbound form for searching, then a new form for results (put in a default query which returns nothing?) On the button click, get the sql statement for returning everything you want, hold it iin a string, then add a where clause with the data typed into the text field. Then open the results...

in the sql query builder/statement: format([table/query].[field],"#,##0.00E") as [nameofnewfield] Where the E is change to euro symbol. Either that or use CCur function to change the resulting sum from your query in a similar way above. Vince

Depends where you are when you want to requery it and whether it is in a form or a subform. Forms("<form name>").controls("<combo list name>").requery or <FormName>!cboLocation.Requery if its a subform and you are in the code of the form, then <subformname>.requery If its a subform of a...

Sounds weird. Ok, try opening the form in designer mode. On the properties of the form, move to the events tab. If there is anything there for open/load delete it. Save and close. If the mdb has no data/sensitive data, compile, compress and zip up and post here I'm sure someone here will be...

Hi, I had a quick go, rough and ready at the tables, mostly concerning the offices and managers/people. I've attached a db in a zip file for you to look at. See what you think, based on your design. You find it useful, you may not. Its just another option and with Dbs there are some many...

The code is referencing DAO. New Access 2k+ dbs reference ADO by default. Go to the code window. Tools>references From the ticked list , disable ADO (Activex Data Objects or something) Scroll down to microsoft DAO 3.6 objects and tick it. Click ok and close the window Debug>Compile Vince

You are going to want a recursive loop. How you do it is up to you and I advise that you do it rather than getting code and its hard enough to try and debug, but if you haven't wrote it, it can be worse :/ I do have code that does exactly what you want except the file size/attributes etc, but...

Dont you put the read only bit in the connection string? www.able-consulting.com (I think) has a list of connection strings and parts there of.... Or do you mean you only want a read only shared area ? Vince

Hi, Nice screen :) Hope that works fine :) Back to the Manager problem... Are the managers detail held in the contacts table (I saw the first time that they were nearly the same layout)..? Almost like my last post , but you could have a manager to contact table which holds: ManagerID -...

Write a chunk of vba which takes the amount of year, percentage and initial amount... Its only a little loop. Vince

Ah ic... Lemm have a think... right. Customers Sites Contacts IsManager - Y/N (default False) This links the look ups of site and manager/contact together... ManagersAtSite MASID - auto pk CustomerID - number (not sure if you need this but you may) ContactID - number SiteID - number Its...

dateadd("d",-1,now)

How about one table with a foreign key to a look up table which has Normal, Trade, exchange, return etc? If you insist/wanna try this layout, you'll need to have a union query (read up on it) with sub queries for totals and a surrounding query to total the union query. eg Select whatever From...

Ok... I am wondering if you need RO and manager tables. Surely these are covered in Site tables and Contact tables and just need a flag/pointer to themselves? So you'd have then: Customer - site -- contact (manager) -- contact --- job ---- project ---- supplier ---- supplier --- job ----...

Your queries (I guess) are using inner joins (as in the display is a single line with no arrow on it). Use a left join from the fruits table to the invoices (fruit------>invoices) and use the nz function to return zero if the invoice is null. To change to left join, double click on the join...

Or you can put it into a look up table (so the rates/change at amounts can be controlled by the customer instead of you releasing an new update whenever they change). From the look up table its possible to use a query to get the information, or you can have a drop down on the page which has the...

On the vba Editing window. Top Left dropdown - all the controls (for form modules) Top right dropdown - all subs/functions If you are in the code and you have a function/sub which you want to see, right mouse click>definition Plus all the other posts above. Vince

Post up your current sql statement. It might (just might) shed some light :) Vince

VBA coding mate... At least for the refresh. Design your form, and since you new to it I'll tell ya the bound way - I personnaly don't like the bound way... for the Source data of the form create a query (use the three dots or create a query and point to that) which has all the fields, and the...