Search results

I have looked but can't seem to find a method to make my form open at full size. Is this possible, what may I be missing here. Any and all answers gratefully recieved. thank you.

Hi Folks, I am trying to create a subquery which populates an intermediary table using the primary keys from four other tables. Insert into Person_Character_Film_Role (PersonID, CharacterID, FilmID, RoleID) VALUES ('" & PersonID & "', '" & CharacterID & "', '" & FilmID & "', '" & RoleID & "')...

Hi Folks, I am creating a database for a friend, the database has four main tables and and one intermediary table ( to remove any many to many relationships) I have popluated the DB with some test data manually and my queries thus far appear to be working correctly. What I need to know now is...

Hello peeps, I have been working on a hours checking application, in which the user can enter their worked hours for the week and the application calculates how many hours at normal rate , time and half rate or double time rate have been worked for the week. All has been going swimmingly, with...

As a primary key, I am using a date, well, at least it is unique, yes? Even if it isn't ideal. Is there a way of making the date autoincrement, like the autonumber does? I thought it may be easier than having to type in a date every day, also the application I am working on will need to have...

Hi Folks, Could someone please point me on the right direction, I need to create a query that is based on the selection of two list boxes, where the selections are dates. I have a basic table which contains a date and the hours worked for that date. I need to select a start date and an end...

hello peeps, I need to update a column based the values of another column. The problem I have is that the other column has four diffferent values so I am at present using two separate queries using the LIKE operator (LIKE "FT*" where the values are FT and FTunit, and NOT LIKE where the values...

hi, I wonder if you can help me? I want to update a record by means of setting flag, trouble is my update query is updating ALL records and not just the one I want. Any ideas gratefully received. Chris

hi folks, I am designing an application for an assignment for college, all seems to be going ok except that I have to teach myself access from a book. When I update a record on a form and go to another page it works fine, but if I attempt the same action ( for example creating an appointment...

hi folks, How do I open html based help file from an access form? I've looked at access help, but it only shows how to put the control on the page, and not how to link the control to the webpage? I'm missing somehting here if someone could help please?

hello, could someone tell how to set up a name search on a form plase? Chris

hello, I am trying to get data from one field in one table to another, depending on the value of a field in the destination table. For example I have field called treatment in an invoice table which has been populated via an append query. Now I need to have the cost of this treatment in the...

hello peeps, I am using an append query to populate a table, the data is migrating ok, but now I want to set a value in one of the blank fields to correspond with the data from one of the appended/blank fields. For example, I am copying a treatment field (from an appointment table into the...

hi, I'm using an append query to copy some values into another table, the problem I have now is setting/updating a field to a given value in the same table I'm copying to which is blank after the append action. Could someone please point me in the right direction in how to set the values of 1 or...

HI there, can anyone tell me hy I can't access/view a delete query when using the the wizard while putting a command button on a form? The delete query is working fine i application mode. thaks in advnace Chris