Search results

Hi All, i've got a very strange problem with an update query. I have a linked table that I grab data from and put into another table using a select query - this works fine. I thne run a query to update info from this table to another table using the code below. The problem that is occuring...

Hi All, Ive got a problem with my table design I'm hoping someone might have solution for: Noramlly I have studentIDs generated on a central database which links my whole databse together. However I will need to generate new numbers for non-students so that the database is still linked...

Hi, Im trying to make a query to update a table i just added an extra column too however I'm getting an error: this query must be updatable I think it has something to do with the join in the query. How would i go abotu creating a outer join? Heres my current query: UPDATE Applicants...

K guys this is driving me mad - the dlookup query is working fine... it will find details for the first record in the form. however it gets stuck on that one whe ni go through the records. I have different dlookups working at the same time properly and changing as I go through records. however...

Hi Guys, I'm not sure if you guys can tell me in the forums but I'm looking for an addin for Access to export my reports in .doc format. The company uses office 2007 but uses access 03 at present. cheers Swillsy

Hi guys, table involved is called [Schedule Details] >> i know its not good to do this now I keep getting an error 3464 with the update section. Heres the code: Private Sub InputClose_Click() DoCmd.SetWarnings False Dim strSQL1 As String Dim strSQL2 As String Dim ArgID As...

Hi Guys, Recently I changed my form so that the dlookup expressions I had to look up values in another table were put into vba. This speeded everything up however now when I search for something it isnt searching for the values. For example before I had a code box and a name box and the...

Hi peeps I have several dlookup expressions on my forms looking up values in other tables which work fine. My only problem is if they cannot find a value becuase it isnt there for the odd record i get an unsightly #error message in the box. Is there anyway of stopping access displaying...

Hi Guys & Gals Someone has just pointed out a fatal flaw with one of my table designs involving incident reporting. Current Structure: tblStudents StudentID StudentName etc tblIncidents StudentID IncidentID IncidentType etc At present the StudentID is linked on tables which means that...

Hi Guys, Bit of a problem here I am trying to add a method of viewing/adding/editing info on a form. tables tblstudent studentid tblrooms roomid roomNumber Block tblScheduleDetails ScheduleID Studentid Roomid Dates Now my main form is based on a query of tblstudents &...

Securing tables for different user groups Hi all, I have a database with 3 levels of users - wardens,admin,managers I would like the wardens to be able to view the everything however only be allowed rights to modify records in certain tables. Is this possible in access - had a quick search...

Hi Peeps Thanks for the help I've had so far with my project however I am stuck with sorting out the basic design for a particular part of the database. Basically I have to keep track of international students staying in Rented accommodation. There will be approximatly 100 students at any...

Hi All, I'm struggling with this expression in a text box on one of my forms and can't seem to find an easy answer via google:). =DateDiff("yyyy",[DOB],Date()) This works out the age of the person as of today I need it to work out the age of the person as of the 01/09/2008 However as I...

Hi All, I've just realised after a couple of days of staring at my editor my VBA skills are limited to functions. I have a problem - I would like to change the background colour of an unbound label depending on a value (yes/No) in a table. The labels are all captioned which match with the...

Hi All, I'm trying to create a 'Temporary' table in Access, I have created it and inputted a set amount of 'RoomIDs'(1-100). I need to enter data into the this table when I load up a form from another called Schedule Details. the reason the table is temporary is so that I can generate the...

Sorry think I posted this in worng section originally, Hi All:) Having problems with two combo boxes on one of my forms - It works fine in the sense that I can get one to populate the options in the second one like so. SELECT DISTINCT Rooms.RoomNo, Rooms.RoomNo FROM Rooms WHERE...

Hi All:) Having problems with two combo boxes on one of my forms - It works fine in the sense that I can get one to populate the options in the second one like so. SELECT DISTINCT Rooms.RoomNo, Rooms.RoomNo FROM Rooms WHERE (((Rooms.Block)=[forms]![Scheduling]![Blockcombo1].[Value]) AND...