Search results

Afternoon all Could someone please give me a hand making a DAO connection to another database, with a view to copying the data in a table on that database and pasting/appending it to a table in my current database. Please note that I cannot have linked tables for security reasons (don't ask...

We have a main database at work with hundreds of thousands of records, but it has changed in to a read only state effectively halting all our users from recording/amending etc. Any ideas why this has happened? 90% of the data is written to the database from excel, but this has been working...

Afternoon This is probably a quick win for some of you guys J but im having really trouble getting my SQL statement to work! Public Sub CheckNewDir() Dim mysrcdir As String Dim myfilename As String Dim fso As Object Dim mydatecreated As Date Dim mydatemodified As Date mysrcdir =...

Hello Everyone I have this code that I got from allenbrowne here > http://allenbrowne.com/ser-59alt.html which does exactly what I want, I was just wondering if anyone would help me make it get more information on the files?? Ideally I need Date Modified and File Type along with the Path and...

Is there a way of making access find the below listed properties of every file in a selected folder, including those in sub folders and list it in a table? Obviously the headers would be as displayed below also Path File Name File Size File Type Date Last Modified Date Last Accessed Date...

Now then all Is it possible to run an update query based on a list box?? The list box displays all the staff that a team leader has assigned to them containing an ID number on the database [ID] the staff name and business ID (M Number) I want the team leader to be able to select a member...

Now then This is probably seriously easy but i cant for the life of me get it to work properly! i want a message to appear if a number has already been entered in to the table, i reckon DLookup is the way to go but i could be wrong My table tblStaff has a field StaffID now when entering a...

Hello I have a form and would like a msgbox to appear when a user submits information using a cmd button that lists which of the fields have been left blank. Eg Field 1, Field 2, Field 3, Field 4 are all blank on the form the msgbox would display as a list Field 1 Field 2 Field 3 Field 4...

Morning This is probably a simple problem but I cant get my form to filter by multiple criteria. And all I can find on the internet is how to define 1 combo box any another. So any help here would be great. There's 3 fields called Name, Site, Age which are accompanied by 3 combo boxes called...

Morning all I know there is a method of producing a list of all the users currently using a database but these always are displayed as “Admin” because it uses the users and groups function within access to get the information. Is there a way of making it display the users windows log on...

Morning all I have a table (tbl1) and I want to transfer the data from that on to a template spreadsheet(spreadsheet1) which has headers etc already visible on the top. I appreciate that its easier to use outputtoexcel etc but i’ve been told I have to use this spreadsheet to send my data on...

does anyone know a method of adding time to a specific date? the data base has a date received box where users enter the date they received there question what i want is a query or method that adds the time they entered the date to the end of the string automatically at the moment ie been...

Good Morning Im having problems automatically sending an email from access I have the following code to send the email, other than the body text the code I a direct cut and paste of a collegues code and his works but mine doesn’t Were both at a bit of a loss as to why? Public Sub...

Now then im exporting one of my tables to a specific folder as an excel doc, im wanting to to automatically format this excel workbook when i press the export button on my form the code i use to export is DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Unlocked"...

Afternoon all I need a quick hand with a couple of combo boxes and would be much obliged if your could help me out I have am creating a search form where the search type is in 1 combo box (called cboSearch) that calls to a table tblSearchCriteria to get its drop down values – the values are...

i know this is probably really simple i just cant get my head round it i have 3 tick boxes on a form called "Form", Field1, 2, and 3 i need a calculated field or a field of some sort that counts per line the number of instances of my tick boxes that are true. Ie if 1 and 3 are ticked the...

Hi guys Is it possible to have a form that appears at start up unless a parameter is set to true, in my case a tick box on the form. The form is a notice of changes that have been made the problem with this being that people only need to read it once and I cant remove it because about 800...

Hi guys & gals Can some try and give me a hand with some VBA stuff? Im not necessarily new to access but I am new to the script side of it (hard to believe I know) because I’ve never really had the need to use it in my job. Basically I have a search form with the location of the 6 sites of...

Hello I have a problem with the search function that CORE helped me with in the Queries Macros and More thread. Basically I have ditched the filters for a standard search function. The user is presented with a form with combo boxes that contain the search criteria eg site, task priority...

Hello all :) hopfully you can help me with somthing that i have been racking my brain with for days now My table data (table called IACS TABLE) is displayed in a form called FrmCORE with in this form I need to be able to filter the data by multiple factors which are chosen from combo boxes...