Search results

Morning! I'm really hoping someone can help! I'm trying to achieve the effect of having 2 nested continuous subforms (see the graphic) which doesn't seem to be possible currently. I need the form to cascade down by date and then by each Temp name on that date. Can anyone suggest how I can...

Hi, I'm working on a database that produces employee contracts. To make it look as professional as possible I hide the Access main window when the splash screen loads using the ShowWindow function. The various forms to check and enter details all pop up without any problem, but when I get to...

Morning! I'm having a weird problem in VBA on a button click. For no apparent reason the database closes itself. No error, no crash - it just closes. I've compacted and repaired it, recompiled it, but still exactly the same. The strange thing is, if I insert a blank message box at the point in...

Hi, I have the following code in a module that sends out various email updates to me when I'm off site. On my PC it works perfectly whether I have Outlook open or not. I've installed the database on several other machines, but I'm getting a Run Rime Error 287 on the .Send line if the user has...

Hi, I'm trying to create an Outlook appointment from VBA, but my code keeps throwing up a RunTime Error 438 - Object doesn't support this property or method. I'm guessing it's something simple, but I just can't figure it out! Here's the code: Dim outApp As Object Dim outMail As...

Hi All, The following code is in a text box on a report in a database that creates work contracts. The IIF statements and Dlookups pull the parts of the text together perfectly, but can anyone suggest why the new line and carriage returns are completely ignored in the last section? Been...

Morning, I've created a filter using a query to list records in a continuous form. In the query I have a criteria in each field similar to this: Like "*" & [forms]![frm_ManageAccounts]![txtAccountRefSearch] & "*" The problem is that if there are any blank fields, the record is not shown...

Morning All, I'm having a nightmare with dates in Access VBA! Here is what's happening: The date is entered on a form using the date picker. Let's say I select 07 April 2013. This is then then transfered to a date variable (dtNewDate). The value in the variable is then inserted into a date...

Hi, I have a DCount in an unbound text box. When the form is opened this takes about 30 seconds to update as there is a lot of data to query! I'd like to display an 'updating data' message underneath the text box that disappears once the box has updated, but I can't find an event that is...

Hi All, I have a form that is linked to a query. The query filters the form by pulling criteria for one of the fields from a function. The criteria is fed into the function based on a combo box with options "Team 1", "Team 2", "All Teams". The issue I have is what to pass through to the...

Hi All, I'm trying to output a table to a CSV file using TransferText in Access 2012. There are 7 fields in the table and they are all formatted as text. One of the fields contains a time that must be formatted as a 6 digit number - ie. 9am is 090000. When I export the CSV and open it in Excel...

Hi, I'm trying to write some code that checks through a table and adds together criteria that is currently selected and then concatenates it to produce a string that is sent to a function and then called from a query. Hope that makes sense! The code is below: Dim rsSelectedGroups As...

Hi, I have a continuous form with a button next to each record. I want to open up a pop-up form that relates to that record when the button is clicked. I have all the correct code in place and the form should open filtered by the contents of the ProjectName filed. However, when the button is...

I know, I know - OLE Objects create huge databases! In this case I only have several very small images, so no problem with size. What I'm trying to do however, is insert an OLE Object into a table using VBA/SQL. Currently I have the following code: CurrentDb.Execute ("INSERT INTO...

Help - my DCount's not working! Here it is: Me.txtOrdersToday = DCount("[AccountNo]", "tblAccountBase", "[UserID] = " & UserID & " AND [AccountOrderedFocusThisP] = TRUE AND [StatusDate] = #" & Date & "#") This DCount returns '0', however, the following query returns '2', which is correct...

Hi, Here's what I'm trying to achieve: I have a continuous form that displays a list of records. I need to display a logo next to each record that relates to that record. The path to the logo is stored in the table and currently I'm using 'Me.imgProjectIcon.Picture = Me.ProjectLogoPath.Text'...

Hi, I'm working on a meeting room booking tool that enables up to 100 people to log in and book meeting rooms into a calendar. The front end is installed onto each of the PC's and these access the back end on the server. It works almost perfectly, but the only issue I have is if 2 people try to...