Search results

Ive just read this on [URL="http://office.microsoft.com/en-us/access/HA012262761033.aspx"/URL] Can anyone explain to me in very simple language, the difference between and ? Thanks. Im using 2003, and trying to find a method to Update a Main Form on which lie various DLookup and DSum Text...

2 steps forwards and 5 backwards Requery has now got me tearing my hair out. I did enjoy the moment though, and the warning is heeded.

Having in the last 2 days suddenly found out how to use Iif (thanks George), and then DSum and then this morning DLookup, I am suddenly empowered and feel freed. For too long I have been stuck in a rut in having to combine tables in queries to get the results I want in my forms. Subforms have...

Think Ive sussed it now - DSUM is the function I needed.

Mmmm, I dont think I have made sense here thinking about it a bit more! My problem is how, having translated Dates into text fields, I can then do any sorting/selection on them. I have tried to restrict my record select (using a subform in the main form) to summing values where monthyear is...

I have a written a time recording database. Users enter job start and end times within days, creating a total from which is subtracted contracted hours (which can vary). Users are allowed to accrue a flexi-balance (hours worked more or less than contracted hours) within any calender month. This...

Thankyou for your thoughts. The justification simply comes from a perception that holding null values is bad practise. I absolutely agree that holding all the values in one table would be much, much simpler and I would have finished what I needed to do days/weeks ago.... However, although the...

Thankyou Sir!

I am writing a time-recording/flexi-time database. I have got as far as creating monthly flexi-time values (worked_time-contracted_time). But employees are only able to carryover 7.40 hours from month to month. I have a Query where I am listing the monthly balances. How do I allow the balance...

OK Thanks. But as there could only be one comment per job entry it seemed better to set the relationship to reflect the reality. In the interim today, to make the database more robust and avoid this sometimes editable sometimes not problem, I wrote some small event procedures using the...

T_Daily_Jobs records time spent on a job during a day using date, start_time, end_time and a job number (which comes from another database). Primary key is "Daily_Record_ID" which is an autonumber. T_Daily_Jobs_Comment records comments about that particular piece of work - the comment does not...

Thankyou for the comments Rural Guy and Pat. I have tried to ensure that my joining query does not breach any condition listed here http://allenbrowne.com/ser-61.html but still I cannot edit the results in the child tables, so I am not sure what to do here. The peculiar thing is that up until...

Hi, I occassionally design databases for use within my organisation - mostly these have been multi table relational databases in Access 2003 for up to 12 users to use on a network, and have worked successfully. But I have virtually no training in database design, and its only a small part of my...

I have used the code from http://support.microsoft.com/default.aspx?scid=kb;en-us;285820 "How to display images from a folder in a form, a report, or a data access page" to display images (of archaeological skeletons etc) in a database. Option Compare Database Option Explicit Public...

Thanks, Ill give it a go Matt

On a Form is there a simple way to use the value entered in the last record as a default value in the next record. I have done this using Combo boxes, but not on a Text Box. Help appreciated Matt

A database colleague has established that the erratic error is derived from the presence of a third table in my initial query. With the third table (which relates only to the parent table) removed, the use of the query to join to tables and be the basis for data entry works smoothly. Matt

Thanks for reply. I do not want to put the child table in as a subform. I want to see the two tables joined in a query with a form showing the results. Subforms prevent searches or filtering on the child form. My question is: Why is the query inconsistent in permitting and then not permitting...

I have had little reponse to this on the Queries forum so am trying here in a hope that someone can advise me. You can tell Im only a dabbler and not a programmer from my language.... Query "Q_Pot_Spec_PR_entry" shows two joined tables T_Pot_Spec_PR and T_Pot_FSN_PR with all records from...

I am getting nowhere with this, and would really appreciate some help. Query "Q_Pot_Spec_PR_entry" shows two joined tables T_Pot_Spec_PR and T_Pot_FSN_PR with all records from T_Pot_Spec_PR, and those that match from the T_Pot_FSN_PR. Clicking in the "Featured Sherd" Yes/No should create a...