Search results

I have an MS Access 2010 database that is split, with the tables back-end on a network share. In another folder of the network share (a folder that nobody but me has access to) lies a second database for a different set of data unrelated to the first one. Is there a way that I can get a VIEW...

Hi all. I thank you guys so much for always being willing to try and help with my ridiculously convoluted problems, and apologize in advance for the fact that this system is complicated in structure. Can't be helped at this stage. Anyway... I have a form (frmFleet) with a tab control on it...

I have a field on a form that's hooked to a PersonNotes column in my table, which is set to MEMO instead of TEXT (so there's no character limit). The field has an AFTER UPDATE command that writes the edit to an Audit Trail (records the username, date, time, field name and field contents) so I...

I have another thread in regards to being unable to get Access to run a batch file. The batch file has exactly one line of code. Is there a way, instead of trying to get Access to run the batch file, to run the line of code that's IN the batch file directly from within Access? Here's the line...

Hi folks. I have a vba function that takes a file named 1.jpg that is stored in the C:\APic directory and resizes it to exactly 240x300 pixels. The file name never changes, the batch file simply calls the ImageMagick script to perform the resize. The problem? It runs perfect when I double...

Is it possible to store a TempVar that contains another TempVar within it? For instance: I want to store a line of greeting in a TempVar, and allow this TempVar to fetch a person's name from another TempVar and embed it in the right place. Like this: TempVars!Greeting.Value = "Good...

Hi folks. I have a query that pulls a list of employees that have at least one call-in-sick date from tblEmployeeSchedules. The trouble I'm having is that this query shows me ALL call-in-sick dates for all employees, and I just want the MOST RECENT call-in-sick date for each employee. I tried...

Hi folks. Here's an interesting situation, and I'm wondering if there's an easy solution that I'm not thinking of... I'm building a 'string assembler' form that allows the user to select items from several combo-boxes, and the resulting values get 'assembled' or concatenated together to form a...

Hey there hi there ho there... I have an Access web-database I'm working on for assigning students to classrooms based upon their choices. I have a table of classrooms and the max number of students per classroom, a table of students, and a table of requests. Students can make more than one...

Hi folks. I always have unique issues, and you guys are champs at helping to solve them. Here's a tough one (at least for me): I have a query that's fetching records. Works like any other query. In one of my query's columns, I want the recordset to return a value based on a variable column...

Hi folks. A brain teaser: I have a main form called frmMain. On it is a tab-control with two tabs. Tab 1, called INFO, has a subform called ctlPeople. Tab 2, called CARD, has a subform, called ctlCard. At the top of frmMain, above the tab control, there is a combo-box that's set to fetch...

[SOLVED] Set a Subform's SourceObject from a different subform on the main form Hi folks. I have frmMain, and on frmMain is a tab-control with a control called tabPeople. This tab-control has two controls, both on the same tab: ctlPeopleList (a subform control that shows sbfmPeopleList, a...

Hi folks. I have been working on making improvements to my employer's Access database application. It does scheduling, payroll and inventory, and it's got some pretty nice features, not to mention the upgrades I have made. Here is my issue: I want to get the data repository (it's a split...

Hi folks. I signed up for a hosting account with Hostgator, and followed their instructions for setting up a MySQL database, enabling remote connections and adding my PC's IP address as an authorized 'host'. The Hostgator account is a linux server. I have an access 2010 application (simple...

Hi guys. I have a pretty locked-down access app that opens print previews of reports whenever a user wants to see one. There isn't a button or any command for the user to send the open report to a printer (just the button that opens the report in print-preview mode), so I put "(CTRL+P TO...

[SOLVED] ConcatRelated issue with TempVars Hi folks, Here's hoping somebody knows a way around this. I have a form that has a field that's supposed to fetch a list of values from a query and concatenate them. I use Allen Browne's code for this:http://allenbrowne.com/func-concat.html Here's...

Hi folks, I have a weird problem... I have two queries that display employee records (one is based off my own employees table and one is built to display records that are still active from an older database table I imported into this database), and each has an EmployeeID value. In tblEmployees...

Hi folks. I'm trying to get a list of employees to print out correctly. I have an employees table, and each employee has a possible four different shifts I can assign them: MIDS, DAYS, NOONS and SWNG (swing shift, half on Days and half on Noons). I tried to create a query that filters my...

Hi folks. I have a complex database that has lots of tables, but for the purpose of this question, I'll simplify things: I have a database with a table called Employees. Employees table has EmployeeID, Name, Date of Hire and Gender. I have a second table called WorkDays with EmployeeID...

[SOLVED] Incremental Times INSERT INTO statement via VBA Hi folks, I'm adding code to a button that sets some TempVars and then executes the following function: Function AddAvails() TempVars("TheTime").Value = "00:00" Do While [TempVars]![IncNumber] > 0 Dim SQL As String SQL = "INSERT...