Search results

I have a weird thing going on and I can't seem to pinpoint the cause. I have Form1 used for data entry. I display the navigation buttons so I can cycle through records, etc. I have Form2 with various command buttons to open various reports in print preview mode. Keeping things to a...

I have been able find threads on moving/running averages etc, but is there a way to perform a moving range calculation in a query? I need to calculate the range between a current row and the previous row. Here is an example: I can certainly accomplish this in a couple of other ways, code...

I have been driving myself insane with this, because I know it's something simple. I am building a SQL statement that requires the use of a string variable. For the life of me, I cannot get this to work. sSQL = "SELECT [lng_RecordID_PK], [txt_QMSCA_CAID], [txt_QMSCA_Source_FK]...

Hi Everyone, After some time away from developing databases, I find myself back into it. In the current database I am developing, I am trying to handle an error. I'm sure it's because I am rusty, but I need some guidance... I have a combo box that selects the type of action being recorded...

This is probably a pretty basic question, but I figure I am making it more difficult than it needs to be by overthinking it. I have an equipment database. I have a table that lists all equipment manufacturers. What I am trying to figure out is how to assign a MFR ID which is sequential to the...

I'm not sure if this belongs here or in the "Theory and Practice..." area. Please move if needed. My question encompasses a front end connected to multiple back ends. It is probably a mundane point, but reading a few articles didn't seem to touch on it. By this, let me toss out that I am...

Certain times and various users, I have front-end users lose connection to the back-end. They end up with error #3043 that says: "Your network connection was interrupted. To continue, close the database and open it again." -If this is a new record when this occurs, all data entry is lost and of...

I've always used an audit trail for tracking changes of records that already exist but I have had a situation come up where I now need to track records that have been deleted. For example, if I delete a record in the datasheet view. I've seen several examples how to do this, with the most...

I am aware of the various methods to compact databases" Access 2003: Sendkeys "%(TDC)", False Access 2007: Sendkeys "%(FMC)", False Access 2010: Sendkeys "%(YC)", False accDoDefaultAction Method DBEngine.CompactDatabase SourceFile, DestinationFile I'm still playing with the SendKeys option...

Realizing the charting limitations in Access, has anyone undertaken the task of creating a speedometer chart in access? Most of the tutorials I've found deal with Excel.

This has been driving me batty for a few days. I am trying to perform a simple task and loop through a folder to retrieve file names. The problem is I only get 199 files and there are over 400 in the folder. Here is my latest code: Sub File_Import() Dim FSO As FileSystemObject Dim...

I am not sure if this is even "doable," but I have the following task. I have a comma separated txt file where all of the values are in one row and separated by commas. There are over 500 values. Why the output is like this is beyond me, but it is. What I need to do is replace each comma with...

I'm not sure if this belongs here or in the "Reports" section, so my apologies if I selected wrong. I have a weird issue that I cannot seem to put my finger on. I have a multi-user application (each user has their own FE and the BE is on the network. I have created a simple bar chart...

Looking for some design thoughts on keeping my DB applications "user-friendly." Like most of you I have a certain "signature" or method as to how I like to see my databases setup/designed. For example: I tend to incorporate menu bars & tool bars into my apps instead of using a menu/switchboard...

Hi Everyone, I've been poking around ad this for a few days and can't seem to come up with an answer. I am using an old school batch file calling the xcopy function to back up some OEM equipment files. IF EXIST C:\BackupLog.TXT GOTO LOG :CREATE ECHO Backup Log > C:\BackupLog.TXT ECHO. >>...

I have a weird problem I can't seem to get a grasp on. I have a split database in Access2K. I have the code below to check the link to the backend: Function Check_Links() As Boolean On Error GoTo Error_Handler 'Checks for the connection to the backend Check_Links = False...

Can anyone tell me how to add a custom description to my user-defined functions? As an example, see the attachment. I've outlined it in red. So if I write a custom function: Function COTH(byVal X as Double) as Double How would I describe what the function is when a user calls it? Thanks

When constructing strings in vba (SQL statements, MsgBox prompts, etc) is it necessary to clear the string when exiting the function/sub? Meaning is it necessary to do something like this at the end of the code: sSQL = "" or sSQL = vbNullString sPrompt = "" or sSQL = vbNullString

This may be a dumb question, but I can't seem to find the answer. Is there a way to round the bar/column corners on the chart? I don't mean the chart area, but the actual bars/columns. (Excel 2003) Thanks, Craig

I'm having a little trouble getting this to work... I'm trying to create a one to many relationship with both update and delete cascading. The code runs with no errors, but the relationship is not shown in the relationship window as being created. Does anyone have any pointers? Dim DBS As...