Recent content by Hunter O.

FoFa, Thanks for the reply and sorry it has taken this long to get back. I am new to using VBA and I’m lost with the code you mentioned above. I have read about a sw_hide command but have not figured out how or where to use it. Thanks Again Hunter

Hello, I am trying to use VBA attached to a command button in another piece of software to open just a form of an Access database. Here is the code that I have copied into VBA and this works fine except it shows everything including the form. Any help in modifying the code to just show just the...

I had help from another forum to solve this but I had two fields with the same name in two tables so I had to give an alisa. I need to read up on this to learn more about my problem and how to prevent in the future. Thanks, Hunter

Problem solved.

Hello, I can run a query but when I try to display this information on a report I get the following message: The specified field “tblMachineData.TagName’ could refer to more than one table listed in the FROM clause of your SQL Statement. Here is my SQL code from the quey. SELECT...

Thanks for the replies but I am starting to wonder is this possible? Thanks, Hunter

Roo, If I understand you, I need to reference the text box on the form that contains the date select on the calendar? If this is correct I have tried that without any success in this db. My goal here is to be able to query tblData by date and not worry about the time portion in the field but I...

SJ McAbney Sorry about the muddy question. I can’t seem to query by date using the calendar like I have in the past on other db. I would like to use the calendar to select the date as the criteria for the query. Thanks, Hunter Edit I am trying to use the calendar date as the criteria in the...

pdx_man I will try this when I get into work just out of curiosity. I have switched to ODBC logging instead of dbf IV since I posted. BTW Your name and avatar and location look familiar, do you also work with PLC? Thanks, Hunter

Hello, I have what is probably a simple problem that I just can’t solve. I have a table that has the date and time in one field that is formatted as General date. I then split the date and time using the Format() function that I found on this forum and it works great. I check the format on these...

Hello, I have a project in Access where I am linked to a .dbf IV file. This file is populated by another software and I use Access to manipulate query the data. This file that I am linked to is now 923 Mb and I can’t seem to reduce the size of it. I have run delete queries and a compact and...