Search results

Hi All, Could somebody tell me how to reference each individual record in a datasheet or should I populate a recordset with the same results and use that instead. Any help would be much appriciated, thank you

Hi All, I've developed a database that was working fine until I split it to use in a network enviroment. The problem is a make-table query that now make it's table in the front end instead of the back-end. I need to run a make-table query because the query uses a custom function which then...

Hi All, I've made a questionaire database as shown in the attached picture. My problem is I've got the same questions on multiple questionaires and don't want to duplicate the questions in the questions table for each questionaire. Any suggestion would be greatly appreicated. Thank You

Hi All, I've made a data access page which is in data entry mode. One of the fields is a date field which I have set the default value as =Date(), but it only inserts the default value when you move to a new record it doesn't put it in on the initial record. Any ideas? Cheers

Hi All, I'm creating a Holiday Authorising database and I'm stuck, I've created a query that checks to see if any authorised holiday falls during the period of the unauthorised holiday and if they do I've written a vb function that returns the dates that match as a comma-delimited string. The...

Hi All, Can anybody tell me whether it is possible to use a global variable defined in a vb module as part of the criterea in a query, if not whether there is a work around. I suppose I could temporarily write the data to a table and use it from there, I thought there would be less messing...

Hi All, Does anyone know of a good free calendar object that I can dynamically add text too, for a holiday planning database I'm making. Thank You

Hi All, Just a quick enquiry if I sort a query by a date field in ascending order then select unique records will I get the latest records. Thank You

Hi All, I've created a table that take the results of a questionaire, with 0 = No 1 = Yes 2 = N/A For each question I want to count the number of Yes, No and N/A in one query. I can get the result for one question by using Count with the critera set to = 0 or =1 or =2, but can't do it for...

HI All, I've designed a report, which is basically a main report Which there is always data for then a page break then a subreport, so each subreport is on a new page. Which works fine when there's data for the subreport, but when there is no data it prints a blank page. How can I fix this...

Can someone tell me why this doen't work If Me.Action_Taken.Value = Null Then MsgBox "The 'Action Taken' must be given", vbOKOnly GoTo Exit_cmdClose_Reset_Click End If I've put a break in at the if statment to check that it does equal null and it does but it still skips over it. WHY?

In the following code how would I make the A1 control reference increase when the i increases i.e when i=2 reference A2, i=3 reference A3. For i = 1 To 33 Forms![Engineer Full Report].[A1].ForeColor = RGB(255, 128, 0) Forms![Engineer Full Report].[A1].FontBold = True Next Any help...

Hi, I've written this subroutine that modifies 2 conditional formats when the 'Finish' button is clicked to the critrea entered in the form 'Control Panel'. This works perfectly but when the form that the conditional formats are applied to is closed and reopened the conditional formats are...

Could somebody please tell me how to set the size that my form will appear when loaded, because it's really annoying me trying to get them to appear at the size I want.

Is there a piece of code I can use to stop a form maximizing on load, so it stays the orignal designed size?

How can I convert a UK Date to a US date in code because for some unknown reason all date literals in a where clause, regardless of where you come from must be in US format. Any help would be much appreicated?

I've written this piece of code to requery a subform but can't get it to work when executed I get the following error :- There is no field 'Forms![Switchboard]![Status not passed to supervisor subform]' in the current record. DoCmd.Requery "Forms![Switchboard]![Status not passed to supervisor...

Hi, I have a combo box which is populated by a table with the fields ID, First Name and Surname. What I want to do is display the first name and surname concatenated and hide the ID column, but populate the field with the ID number. Is this possible?

I have made a top value query that pulls the the 5 latest audit scores a certain engineer has acheived, but now I want them to populate 5 textboxs on a continous form where the engineer in the query equals that of engineer on the form. I can pull values using the domain functions such as...

I am trying to use DCount to count the number of record that = 0 for field checklistitem_1 in table 'Data Input'. I firstly tried =DCount("[ChecklistItem_1]","Data Input","[ChecklistItem_1] = 0") but this returned nothing. So I tried =DCount("*","Data Input") just to see if I could get...