Search results

Hey AWF, Do we include attachment & inserted tagged code in our site searches, and if not, is it possible? I've been trying to search things on this site for the last month or two, who knows, one month feels like two months and then the next thing that you know, two months go by and it is only...

Hey AWF, I'm wondering how I can cycle through a set number of lets say 10 seats numbered 1-10, with 10 alphabetic names of A:J, and they are left to right. In this case, people will shift a seat to the right, but not everyone, and I need to record their new seat number. Is there an efficient...

Hey AWF, Just curious why and how objects appear differently in the navigation pane. I haven't seen a setting to modify under navigation options, but sometimes I look at sample databases and the objects are much bigger with more detail associated with them as shown in pic #1. If i create a new...

Hey AWF, Hypothetically if I have a form event that had a Private Sub PlaceholderNameRoutine_Click() Dim db as DAO.Database Set db = currentdb() 'call function(i) TestMyCurrentDB1 set db = nothing End Sub Which called 9 other functions in a module/subs such as TestMyCurrentDB2, 3, 4, etc -...

Hey AWF, I'm looking for an old post and wondering if it rings a bell in anyone's head on where to find. Can't remember if it was an AUG group, forum post.. I do think the example used was Microsoft's webpage where you have your header as such: And then on clicking one of the header items...

Hello AWF, I have a combobox that is reverting back to the old value when I edit it and I can not figure out why. I have a Not In List event that adds the record if it does not exist, but it is inconsistent with keeping the new value that was just edited, or reverting back to the original value...

Hey AWF, Any takes on suggesting how you would modify this form to be more visually appealing? This is a full screen display form - maximized, resized to whatever 15 inch laptop to 72 inch tv is being used as the display. I'm getting ready to at least turn all of the underlined blue texts into...

Hello AWF, I've been trying to implement @MajP 's FAYT continuous form class to filter two subforms from my main form, but I can only get it filter 1 subform and not both at the same time. I'd like to figure this out so that I can reuse this concept. I've tried initializing the class from each...

Anyone care to share some songs or contribute to a music thread? Currently listening to this gem - not endorsing, but somehow came across it tonight, and I was introduced to it by a fellow coworker at my first job.. Out on the lumberyard mud field with a chainsaw and putting together all of the...

Hey AWF, Happy Monday. I'm trying to draft up a decent way to put together an inventory calculation for a new database that we are implementing. This is a pretty simple supply/demand model - I would say more similar to receiving a sales forecast, purchasing towards it, and receiving it - that is...

Hello AWF, Scratching my head with this one. We receive a scheduling file that we import into our database to build the kits on the order, and sometimes the next schedule update will be a revision that modifies the orders. The problem is when there are deviations requested to the part kits, and...

Hey hey, Sup AWF. I was wondering if it was possible to modify this example access file to be late binding vs early binding. I modified the sample file quite a bit to get everything that i need -- but now that I have a good solution in place, I would also like to change this file from early...

Hello AWF, I have a task table like below, and I am trying to write a query that returns the 2nd table below. I need to sum up the task_secs by station and have a column for each model. The by model sum includes each task_secs where there is no model. So for station 1 model 1 - it will sum the...

Hello AWF, Does anyone have any experience or code with searching all database objects for a sql string? I've started looking at how to approach this over the last few days and haven't come up with much.. Other than the export to text and then search through text files. Basically - I've...

Hello AWF, I'm having a problem with a text box value not updating as the form record source is being updated. This was working fine with an Access back end, but now that I have migrated to sql server it does not. The attached sample database is my attempt to simply explain the problem. User...

Hello, I am facing a problem with a combobox on the start form of one of our db's after sql server migration. When doing a debug.print the correct values are returned in the form_load procedure, but this combobox stays blank. I've added a requery on the combobox in the form_load procedure, but...

Hello AWF, I've spent the last two days trying to figure this out and am not having a good time. I have a report that is sent to a PDF file which has been working well, but one of the users is getting spillover on the report and it is adding extra pages. For other users it is working okay. I've...

Hello AWF, Can anyone share a preferred method of concurrency testing? I've migrated Access BE's to sql server and made modifications, optimizations, configured data types, set up views in sql server, etc, and the speed/performance seems great so far. I now need to test multiple users using the...

Hello AWF, What is the best way to pass a hidden text box value to a sql server view? I have a hidden text box on one of my forms that holds the department an employee belongs to. This is how I have done it in access. SELECT tblEmployees.emp_id, tblEmployees.department FROM tblEmployees WHERE...

Hello AWF, I'm trying to optimize multiple queries such as this one below. Does anything jump out that would help optimize this? I've been using the link below and identified my problem queries that take the longest. I'd like to approach this to achieve the quickest possible query run time...