Search results

I have a number of users using a database. They input data using a form. The database is split into Front End, Back End and i'm pretty sure that the record locks are set correctly and the users should not be able to delete records unless it was by accident evn so it would have to follow a number...

I thought this'd be simple but I can't figure it out. For reasons of laziness and the need for a quick fix I've had to make a copy of my database - FE and BE - so that all records for this year are held in one and last year in the other - (extraneous info: My users need access to this year's...

Hi there I've done this before yet can't remeber how I did it. I need to change the location of my backend data tables can anyone point me in the right direction? cheers in advance

is there anyway of seeing how many users are using a database at anyone time and if so is it possible to show their individual IP address or something?!

hello can anyone tell me how I can implement this SQL expression in a text box on a form SELECT Accom_record_card.Export_ctrl, Count(Accom_record_card.Export_ctrl) AS CountOfExport_ctrl FROM Accom_record_card GROUP BY Accom_record_card.Export_ctrl HAVING...

hi there had a search for this but kind find anything similar.. i have a calc field using a DateDiff function that gives the number of weeks between two dates - i don't want to use days - but i want to use part weeks - is there a way the function can give the number of weeks as a decimal...

i have a form with a load of event procedures behind it - for some reason when i try to view the code it won't allow me. When I try to access the code through VBA the form is no longer on the Microsoft Access Class Objects list - yet the individual properties on the form still show that they...

Okay fellas and lasses please help me out if you can. I had this code below on the before update event of my form and it works like a dream - creating different flags for different levels of data... howver I want to add a new event that pprompts the user to dsave the record if the make any...

Hi I'm attempting to split a large flat table to make a relational database because it's gonna get accessed via the web using ASP eventually... and it needs to be slick with little redundant data etc etc... if iwas starting from scratch this wouldn't be so hard - but i gotta keep the data...

hi does anyone know if it's possible to change an export file name automatically.... to fill you in with my export function this is the code I'm using: Private Sub Command90_click() 'export new records to SAP function Dim rs As New ADODB.Recordset Dim sql As String On Error GoTo...

hi comrades I want to have a value stored in a form yet expoprt as a null - I have a combo list - Deluxe, Standard, None - on the export the bound column exports a code letter (i.e. W, O, Null) - however on the form I want it to show up as 'none' - at the moment it looks like the field is...

what is the correct syntax for this... I have the following and it doesn't work - If IsNotNull(.Room_Number) And .Export_ctrl = "4" Then .Export_ctrl = "1" can anyone enlighten me on my error - i get the 'Compile Error, sub or Function not defined' many thanks for whoever...

hi folks I currently have the following code on a form: Private Sub Form_BeforeUpdate(Cancel As Integer) With Me If .Dirty Then If .NewRecord Then .date_stamp = Now() .Export_ctrl = "1" Else .date_stamp = Now()...

hi I've developed this form that contains some cascading combo's. They work fine and the data gets written to the master datasheet etc... HOWEVER... when I go back to the form - the data in the fields controlled by the cascading combos is NOT (always) VISIBLE for every record and when I...

i have searched for this but not really found anything similar: I'm sure it's dead easy but I want my check boxes on my form to store codes instead of '1' or '0' for export purposes. eg. a check box for Data Connection? (YES/NO) would store code 'A' if checked and ' ' (ie. null) if unchecked...

howdy folks what i want to do is have a msg box appear when a user clicks a button to Export records. the message box will say " You are about to export (x no. of records). This will update the current data base. Are you sure you wish to continue?" x will get it's total from a count query is...

I've been given this job to do at work where I have to steamline this database (a flat table created by someone else) so that I can automatically export Standardised data to an all singing and dancing SAP system. I have done all the relatively hard work (with a little help from this Forum I...

I'm building a form and I have the following code which works to a degree: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.date_stamp = Now() Me.Export_ctrl = "2" End Sub the code adds a modification date if a record is modified and also flags the record as a '2' which means it has been...

I'm trying to design a query that uses a Boolean expression to create a calculated field that looks at a field to find whether the looked up field = 1 OR 2 I'm not sure on the syntax see below and help me with the parentheses etc: Newfield: IF([Accom_record_card]![Export_ctrl] = 1 OR 2 THEN...

Okay i will have three or four fields that i need to use to create a new field that shows a code based on the data in the other 4 fields . e.g. if the following is Location field = 'Manchester' Rsidence field = 'Brookfield' Room type field = 'Standard' Bedding type field = 'With Towel' These...