Search results

Hey all, I'm developing a gradebook database, and for grade input I have a list box of students that users can select multiple students at a time from. I'm having a problem getting the recordset to the right record, and actually I don't think its moving to the right record at all. Here's the...

Whether this be because they are poorly received or because someone such as yourself shouldn't be playing a particular type of game, what are some game that you hate to admit you enjoy?

Hey all, I've uploaded my database to a server, and now whenever I try to open a particular form it show up completely blank. I can open it in design view and all the controls are there, but if I try to actually open the form to use it has absolutely nothing on it and does not show any...

Hey all, I've got a form that monitors values as they vary between certain points of time, and I was wondering if someone could point me in the right direction for how to change the text color of the text box font if the value in that box goes negative. There are about 200 records the person...

This forum section seems a little under-appreciated, so I thought I'd throw this one out there. What video game stands as your favorite/least favorite game of all time?

Hey all, My form contains 4 combo boxes and a subform. When first opened, all the combo boxes are blank and the first one is the only one selectable. Once a value is put into that, the subform's query is to update to match the input from the first combo box and the second combo box becomes...

Hey all, Is there any way I can monitor the size of the database itself and then perform actions according to how big it is? Example: once it reachs a certain size, pop up a window to suggest running a compact and repair? Let me know if there's a way!

Hey all, I've got a couple of tables that contain numerical data that I am finding the difference between. Both are defined by the same PK, and with an inner join the query correctly shows the differences of all the PKs that exist in both tables. However, I need to have the query also show...

Hey all, Is the following statement syntactically correct? SELECT tblFD.Payor_Code AS [Payor Code], tblFD.Payor_Name AS [Payor Name], tblFD.SRCol AS [S/R], Sum(tblFD.Inbnd_Bytes) AS [Inbound Bytes], Sum(tblFD.Otbnd_Bytes) AS [Outbound Bytes], Sum(tblFD.Bytes) AS Bytes...

Hey all, Would anyone have any idea why my database will properly import my data sometimes, then other times completely mess up the import? I can use the exact same data file and like it said, sometimes it imports fine and others it just messes up completely. I believe the issue may be in...

Hey all, I need to have compact and repair run after my import code finishes. How do I code that so that C&R executes at that time? Sendkeys may work somehow, but I haven't exactly heard good things about using that. Thanks ahead of time...

Hey all, I'd like to be able to compare data entered on two different dates (such as data from 6/4/08 and 7/3/08). I've kicked around a few things but can't seem to find a way to accomplish this. Any suggestions toward accomplishing this would be appreciated! The comparisons probably need...

Hey everyone, I'm working in a database with gets its data from a text file, then assigns values in a blank column to the imported data once imported. The problem is that once I start the import process for another file the recordset starts back at the beginning of the table and I overwrite...

Hey everyone, I'm trying to generate a report that needs to have its record source based on what option (of 2) a user selects. A different query will be called depending on the selection. Any suggestions to help point me in the right direction would be great, because I seem to be running in...

Hello everyone, I've got a pivotchart that uses information from a query for its data. I recently made a small adjustment in the data being taken in and now get the following error: "The specified field 'Payor_Code' could refer to more than one table listed in the FROM clause of your SQL...

Hey all, I'm working on a database that has data in four columns in one table. What I need to do is take that data, compare, then replace it with data from a single column on another table if the code matches in either column. Just to help clarify, I've got two columns of code numbers in...

Hey all, I don't know if there is a way to help with this one, and it's going to be slightly vague in description, but I'm currently working on a database that imports a text file for its data. Problem is that sometimes it will import correctly and other times it will mess up like it is its...

Hey all...again... Alright, so the code I've got now works, runs, and doesn't throw any errors, however it doesn't quite work right. What the following code is supposed to do is grab two values from one table, smash them together, then place them into another table : Public Sub...

Hey everyone, new question. Is there any way possible to have row breaks in the imports specs of access 2000? While the data I'm importing is mostly in columns, it does change its "header" (if you will) for different customers. I suppose you could look at it like bank account transactions. See...

Hey everyone, I'm new here and looking for a little help. I've got a table that has a date field, and I need that field's default value to be assigned to a user-entered date. I've tried the following: - Having the date field's Default Value option call the text field on a form that the value...