Search results

I am working on a report in SSRS. I have created a calculated field using the IIF function. I now want to group my data by the values returned from the if statement and use them as parameters. The grouping seems to work well, but when I create the parameter I end up with more than one value the...

Hi Apologies if this has been answered before, but I cant find it anywhere. I am currently trying to open a form and show records on a specific date. I have created a form which isn't bound to a table and has one field for the date which is being searched for and a button to open the form that...

Hello I am currently trying to get a spreadsheet to import into an access table at the click of a button. The code I am currently using is below DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "Details", "filepath\LearnerSupportCollegeProvision.xls", True, " " I have tried this...

Hi. Apologies if this question has been posted before, but I couldn't find it when I searched. I'm trying to populate 4 fields with percentage amounts when a button is pressed. It appears to work fine when done as a number, but when I change the format of the 4 result fields to percentage it...

Hi there Im working on an update query to add 2 zeros to the front of a field where it is less than 8 digits long. I'm not sure how to go about this, can anyone help me out? Cheers

Hi there, I'm trying to create a button on a form that will allow my database user to import from excel by browsing. I'm currently using the code below which allows them to import providing the file is in the right place with the right name Dim stMessageBox As String...

Hi all In my current project i'm trying to get a tick box to update a date field with the current date and to revert to 'no date or null'. This is the code I'm currently trying to work with. Query Completed is the tick box and DateQuerySolved is the date field. Can anyone help me with this? If...

Hi there Sorry if this is a 'n00b' question. I have a text box on a form that I want to make visible or invisible by clicking a button. This is my current code: If Me.txt4Comments.Visible = False Then Me.txt4Comments.Visible = True End If Exit Sub ElseIf...

Hi all Im currently trying to set validation rules for a form using VBA, does anyone know of a good method of doing this as i'm a bit stuck:confused:

Hi, Im currently trying to write code to save records to a temporary table. This is the code I have so far: Private Sub cmdSaC_Click() Dim strSql As String Dim rstSaveTemp As Recordset Set dbs = CurrentDb MsgBox "Are You Sure you want to save and continue this form at a later date"...

Hi all, i'm new here and I have a query about a database i'm building with which any help would be appreciated. I'm designing a form and I need to be able to have an option to save to a temporary table for retrieval by users so that they can continue their saved record at a later time. Does...