Search results

Trying to use a form based on a table to choose a recordset of values, and pick the ID of that recordset to include in another table as a foreign key. I am not sure how to even search for what I'm trying to do, though I've tried all the variants I can think of anyway. The idea being that there...

I'm attempting to set up a locked excel file to be used as a framework that has a command button with vba code attached that will save the edited file as a new file name. The code seems to work, insofar as it does time stamp and rename the file as I intend. The problem I'm encountering, is that...

I am currently attempting to import a CSV data file that lists information in a top down format that I need to convert to a compacted flat file form for further calculations and manipulation, but cannot figure out how to to do so. I believe I'm missing something basic in how I'm doing my select...

I haven't even been able to find the right criteria to search for in the forums to get meaningful information, so I'll pose this question, and hopefully someone can answer, or point me to the correct keywords. I wish to make an update query which would populate a table based on the number of...

My data comes into the database from an outside source, grouped by Quarter for the first two years, and by year after that. I'm able to summarize data in the various footers (6 at present), for various time periods and criteria, as they're just straight vertical sums. However, when I reach the...

I have a series of checkboxes, used to classify query criteria, such that you can run a report for 1st Quarter, 2nd Quarter etc, or by year. These are located on a form; however, when choosing a start and end date, I'm wanting to restrict the check box selection such that if your start period is...

When attempting to run a Delete query via VBA based on a combobox, I'm getting the following error: "Object does not support this property or method" I'm unable to find anything via search that says this is, or is not possible. I currently have a simple form, with a combobox and a command...

Three questions actually: I've created and saved my spec file for importing my space delimited files, however the last column is truncating to the first letter only, when run manually or via VBA. Spec file contains 7 spaces for the field, and using an editor on the txt file shows 7 spaces...

I'm not certain how to handle this one. The data import procedure in my database is simply a set of VBA/command buttons that allow the user to browse the network and select a CSV file. The code deletes the existing table, and imports the new CSV file as a new table, and proceeds to append/update...

I'm trying to figure out how I can set a parameter on my query to search for any activity that occurs within a month, that falls within a date range. Specifically: Criteria TextBox: 4/2006 Activity Start: 3/6/2006 Activity End: 5/5/2006 I want this activity to show in my query because the...

Is it even possible to programatically change the criteria and resend a report? At present if I want to run a report for every month of the year, (not summarize, but a detailed report for each month in sequence) then I have to manually change my time period and click the command button to run...

What I'm attempting to do is create a database storage of fixed information. This is the current situation: Monthly, a user enters forecast information which is eventually finalized, and reports are generated. Then modifications are made, and new reports are generated, but the problem is that...

I'm not sure if I'm looking at this problem correctly, but here's what I have set up (as close to 3NF as I can manage using generic names for simplicity below) tblDatatype1 & subtblDetails1 tblDatatype2 & subtblDetails2 tblDatatype3 & subtblDetails3 tblDatatype4 & subtblDetails4 tblDatatype5 &...

I'm attempting to put in some VBA code to simplify data entry, by updating controls on a subform based on prior entries. In essence, as the user enters values going from left to right, these values can in some cases, modify values further along the list accordingly. However, my problem seems to...

I have created a query with one row of data, and six columns in this layout: Month/Year in Question, Location, Criteria1, Criteria2, Criteria3, Criteria4 This layout could change to two rows at some point in the future, though I could create a second query where the Location is unique so that...

I'm not sure I can find anything quite like this elsewhere with the search function, following examples in other threads it's like my filter is being completely ignored, gives an error, or shows no records. Here's the situation: This database contains forecast information by month, so upon...

Within my VBA code I was attempting to input some error handling, but I'm getting a looping effect I can't get out of without Ctrl-Alt-Del and killing the process. I also am unable to determine what the error is that's occuring, so therefore, am unable to repair. Here's the VBA sub in question...

Perhaps this isn't the most appropriate method of verifying user identity, as someone could use an existing login on some server, or login with someone elses password, but I believe that shouldn't be an issue to deal with here. I've spent the past 8 hours poring over the boards, and can't quite...

I've been unable to find anything in the archives about this so far, but what I'm attempting to do is create a query based on tables with three columns; for the express purpose of creating a graph on a report. The first field is the day/month/year. Second field is forecast month to date...

I have a form linked to a table, What I'm attempting to do is open the form and filter the data. At present I have the form set up so that the On Activate function calls a macro with unbound boxes that merely asks for the month, and year for which you are going to manipulate data. This macro...