Search results

I have form that can pop up a second, modal form. The modal form contains about 6 subforms. Everything was working peachy until this morning. Now when you hit the button to call up the modal form, it asks me for all the parameter values for all the master/child relationship fields for all the...

I have a table that stores time worked by number of minutes. I want to display those times for editing, but of course I don't want to show the user a number of minutes, I want to show him times. But then I also want him to be able to type in a new time in HH:MM format and then store it back as...

I swear I saw this on here a few weeks ago but I've spent the last 2 days searching for it with no luck: I want to make a form with several subforms that can be expanded / collapsed in the traditional + / - method. I could have sworn I saw an example database posted here that did exactly that...

I have one form that is opening extremely slow, I'm trying to troubleshoot why and I'm looking for some general info. The form contains 4 subforms and one thing I'd like to do is keep the subform on the main form but not load it, so that I can keep stuff on there but diagnose if any of them are...

I have a payroll system that is dealing with a lot of time intervals as opposed to an absolute time (ie; 8:30 is 8 hours and 30 minutes, not 8:30AM) and I need some advice. I've searched this forum a lot and read this: http://www.mvps.org/access/datetime/date0009.htm Which seems like it would...

I have a query that if run alone, returns the records I would expect. However, when I bind a form to that query, I get no records returned no matter what I do. Is there any reason this would happen? My other forms bound to different queries work as expected. The query (the hardcoded date is...

I've been developing a payroll problem recently and it started blowing up when it was 2009 but the next payroll ending date was in 2010. I abandoned what I was using (it had other problems) and recently went to the DateSerial function, but I feel like it will have the same problem: Public...

I've been pulling my hair recently with table design with regards to values that are sometimes based on other data but sometimes not. The problem is this: the company I'm consulting for enters in the hours each employee worked on each job. The total hours for the day is sometimes accepted as...

I've been running around with this for the past 2 days but I really don't think I have the query chops I should to unravel it. The background: 2 Tables, first holds PayrollNumber, WorkTimeIn, WorkTimeOut, and WorkDate. The second holds any adjustments to those entries called AdjustmentHours...

I'm using SQL linked tables in my Access program and just came across an interesting statement in this old thread: http://www.access-programmers.co.uk/forums/showthread.php?t=44095 Now this is my first time working with SQL server in any meaningful way, so I may be missing something, but what...

I have a new database that I'm trying to design an interface for. It tracks a series of plumbing job, and each job has several tickets (1 for each day a plumber is on the job) and each ticket has several lines of materials. What I want is a screen where you open a job and it lists all the...

Hello all - I have a program that I am mildly modifying (I did not write it) and everything is gravy except they want to be able to see the navigation pane only while a certain form is open. I was pretty easily able to hide the pane via VBA when the program starts and when the maint. form...

I currently have a main form and subform about a work ticket, the main containing the header and sub containing the lines. The two are linked via the ticket number and everything is cool, but they want to be able to filter the lines based on status. What is the *right* (I know there are...

This is (for me) a fairly complicated SQL statement and it has a problem that I can't track down. Access, however, only gives me the generic "Too few parameters (expected=1)" error. PaymentSource = "SELECT [tTransPayments].[PaymentAmount] FROM [tTransPayments] " & _ "INNER...

Hello all. I have a new project to build and it's significantly bigger than my other ones. It's replacing an old VB program so we were thinking of developing in the new VB.net environment, but I'm finding making the switch from VBA to full VB a lot tougher than I had anticipated. So it's gotten...

I have a complicated form with several subforms, everything works as it should. I added one field to the table the main field is based on, then I destroyed and recreated the link between the table and the field. I added the new field to the main form and it shows up as it should, I did nothing...

Ok, I honestly have no idea what the problem is here, but it's giving me show-stopping errors and I need some help. In my program if I try to either add a field to a table or change the name of an existing field, I cannot reference the new field in the code, I get an error (usually "Variable...

I have a form that opens with 2 empty subforms (items and payments) that later get filled in. Each subform keeps a running total of the items they contain, then the parent form holds the grand total of both. No matter what I do, I can't get the subform totals to show up as 0 when the subforms...

It's likely that there is something simple that I am missing, but I have been banging my head against the table all day with this: I have a form that needs to calculate the total based on the changed values in a subform. The subform changes and recalculates correctly, however the text box on...