Search results

I have two buttons to open a form, one to add records the other to edit records. The 'Add New Record' button also writes some of the information to a second table. The 'Edit Record' button only updates a field in the second table if that field has changed. Both forms are identical but with...

I am trying to populate a multi select list with options available depending on room type. I can get either the Package or Rate on the list but not both, this indicates my strSQL is ok. I have spent all day on this forum and the web but still have not succeeded so here I am, cap in hand, asking...

Opened my application this morning and all the data has disappeared from one table only but the table structure is still there. Spooky. Anyone else had this problem?

I have a form with an option group to select subforms to be displayed.To save space on the main form I have added a subform (frmSubService) to the option group to display some of the data that was originally on the main form. The subforms data source is the same as that of the main form but only...

I'm not sure if I am biting off more than I can chew. I have a text field in each record in my database (Inherited) The db has nearly 5,000 records. I would like to split the field into records in a seperate table. An Example of the table as is now; MemberID Boats 5882 Opossum(78-80) (87-89)...

I am using Access 2010. I Have the 'Display Status Bar' box ticked in Application Options but the Status Bar is not being displayed. Any suggestions please?

I am trying to code a button to select a file path. I get a compile error: User-defined type not defined on the following line; Dim fldg As FileDialog

I have a form frmUpdateSubs with a subform frmSubTransTemp. I have a control Running Total on the main form with a control source of =Nz([Forms]![frmUpdateSubs]![frmSubTransTemp]![txtSum],0) Every thing works ok when I open frmUpdateSubs. I have a main form frmMain with an option group 'Menu...

For some hours now I have been researching how to pass a parameter to a query in VBA. I can't get my head around it - I must be thick. I have a function that when called transfers a query recordset to an excel spreadsheet then emails it. At the end of the function I use code to write the date...

I am creating a function to produce and email a report as a PDF file. The filter in the DoCmd.OpenReport does not work. The function works in that the files are saved correctly but each one contains all the records in qrySubs1 not those just relating to a branch. I would like some help please...

I inherited a db where dates were stored in a text field. I added a temporary field to the table of Date data type. I ran an update query to update the temporary date field to the date value of the text date field. I then deleted the text date field and remamed the temporary date field to that...

I have a function to transfer query results to a spreadsheet. DoCmd.TransferSpreadsheet acExport, , "qrySelUpdatesCurrent", _ "C:\Users\Submariners\Documents\WeeklyFullUpdates.xls", True, "Current" DoCmd.TransferSpreadsheet acExport, , "qrySelUpdatesLapsed", _...

I have the following code in a calculated field in a query which is the record source for a form. Test: IIf(IsNull([NatSubsBranch]),"",IIf([NatSubsBranch]=1,"Standing Order",IIf([NatSubsBranch]=_ [BranchID],"",DLookUp("Branch_Name","tblBranch","BranchID=NatSubsBranch")))) When I run the query...

I'm a newbe to Dreamweaver with dmxAjaxDatagrid. I have spent a long time looking for an answer but no joy. I want to make the name column a mailto: hyperlink to the email column in the grid which is hidden. I can get the email address to display under the name but on clicking, the email address...

Trying to update a table using vba. I have a problem on how to get quotes around a string variable in the sql statement. when the sql executes I get a popup asking for parameter for whatever word the variable is. If I enter the word the table is updated. The sql string is: sql = "UPDATE...

I have a form with a multi select list box. I need the output to be a list of rows selected seperated by a comma. The code that I have puts a comma at the start of the line i.e , Secretary, Treasurer Private Sub Command2_Click() Dim frm As Form, ctl As Control Dim varItm As Variant...

I have a form with a make filter function to enable users to pick to display records. I have an option group allowing users to select records begining with a letter or number or begining with a group of letters. I have a check box control 'StatusActive' which when clicked should, when clicked...

I have had a motherboard failure in a desktop PC. It was running XP and was an OEM machine (DELL). I have installed the HD in another machine and as predicted got the BSD but it will boot in safe mode. I have recovered all the user data. Is there any way that I could recover the installed...

The following code works if Me.txtFrom is a date but not if it isn't. I copied and pasted the 'True' SQL string from the true case and removed the references to Member_From and Me.txtFrom putting it in the false case. If I run the procedure with no date in Me.txtFrom I get a message box 'Syntax...

I have a table(tblMaster) with a field(SUBS1) that contains a string of names seperated by a space. I want to split the field into names and put each name together with the ID field into a separate table(tblBoatMember). I get an 'Invalid use of Null' error on the line vArr =...