Search results

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...

Does anyone have any good references for converting DAO to ADO by example? One thing I have really struggled with is finding a good reference source to convert my DAO to ADO. I know queries need to be optimized, and views implemented where possible, etc.. That is about the extent of my...

Hello AWF, Trying to optimize some db's that have been in service for years, and have been struggling with speed, program not responding for 2-20 minutes, etc. Typically if speed is bad I will close sessions of the backend, compact & repair, and release it back to production. This usually speeds...

Hello AWF, I'm experiencing a problem with a function - UpdateData() in my db, and hoping someone can tell me if I am missing something. I have an update procedure that runs each morning, and it usually takes 20-30 minutes. Recently it has been getting hung up and taking over an hour, and...

Hello AWF, I have just migrated a back end access db to sql server, and have been altering code to include the dbOpenDynaset & dbSeeChanges as I was getting error messages about needing dbSeeChanges when interacting with IDENTITY columns in sql server. The below function is called in a...

I have a table with 2 columns - email_group_id(integer) and email_group(long text), where email is a string of emails. I have a saved query that selects from the table, and I open a recordset in VBA with the saved query, and assign a variable "Em" (dim as string) with the email field. When...