Search results

Greetings all, I've developed a split db (A2010) that has a FE installed on local machines(7 users in all) and the BE up on the network. The issue I'm having is that if one person opens the front end on their machine and they open up a report, or a table (which I have setup using a datasheet...

Greetings all, Have a wierd question that I have not found an answer for so I thought i'd post it here. I started a new gig and inherited a database. Database was originally created in Access 2003, but was upgraded to 2007 format. Database is split but runs locally on my HD for the time...

Greetings all, I have a problem and was wondering if I could get some help/hindsight. I have a information file that I need to process. The file is HUGE. Plus it is denormalized, meaning that it has header info, type info and origination info, as well as the records being processed. In...

Greetings all, Have a unique scenario here. I am calling a stored procedure in SQL Server 2008 from my Access 2010 database. (see my code below). Dim objConnection As New ADODB.Connection Dim objCom As ADODB.Command Dim x, y As Variant Dim rst, rst2 As ADODB.Recordset...

Greeting all. I have a question regarding an error I'm receiving when running an SSIS package that xfers data from a flat file to an 2003 Access db. SSIS is able to find the flat file and recognize it. Also, SSIS is able to connect to the database using OLE DB (see attachment 1). There is a...

Greetings all I have a popup form which is used to provide data to a function. On the form are two combo boxes.... these are used as criteria to populate a listbox. When the user enters data in the second of the two combo boxes, I do a requery of the listbox (from OnChange event). I also do a...

Does anyone know if its possible to programatically set the "document window options" in Access 2010?? I'm able to hide the ribbon and navigation panes using VBA and I also want to prevent the tabs from showing using VBA as well. TIA, Tim

Greetings all, I have a procedure that worked fine until I upgraded from Access 2003 to Access 2010. Below is a snipped of the code: Dim xlAP As Excel.Application Dim xlWB As Excel.Workbook Dim xlWS As Excel.Worksheet Set xlAP = CreateObject("Excel.Application") Set...

Greetings all. First, wasn't sure whether to post this here or under queries so I'm posting here so sorry in adavance if its the wrong area. Ok, that being said, here's my problem. In a application that I'm developing an Access 2010, I have created a query which has a column that calls a...

Greetings all, I'm working on a large documentation project. I inherited several large Access db's (created in 2007, upscaled to 2010 prior to my inheriting them) and I need to print out each object and its associated description. I thought I could query one of the system tables to obtain...

Greetings, I'm currently using .addnew and .edit methods to update a table in VBA. I have a flag setup so that if a new id comes in , then I use the .Addnew method to add a record to my table. Some of the records are update records, which need to have data pulled from certain fields, then...

Append query and Leading 0's in field names Greetings all Came across a problem and wanted to see if anyone else has seen this or knows the cause. I am working in Access 2003. I have two tables stored in a backend. One table updates the other. The database I inherited was doing this via...

Greetings all, I have a report in which I need to change the groupheaders from section to section depending on what the value is on the top header. i.e. - Groupheader0 = 1. Groupheader1 = AA Groupheader0 = 2 Groupheader = BB Can this be done mid report? or...

Greetings folks, Started getting an error on friday that is not only baffling me, its baffling my helpdesk crew as well. I am using Access 2003. I had been getting the occasional MS Access exception error when attempting to save my database. Compact and repair usually fixed the problem but...

Greetings all, I have a client who initially hired me to convert an excel spreadsheet app to an Access app. Well they have now made a request (actually, more like a demand :mad: ) to use Excel as the input tool with the data being housed in access tables. I've never done this and was...

G'day folks, I have a piece of code that I use for one of my Msgboxes that uses the "chr(13)" for line breaks. It works fine. When I try this same approach for text in a memo field on a form, it doesn't. Does anyone know if this is possible? I've included my code below to give you an idea...

Greetings all, I did some searching on this but did not see anything that answered my question. My supervisor is requesting (demanding actually) that I switch our Access app from an mdb file to an adp file. The app is standard fare(FE and BE, the latter residing on a server on our network)...

Greetings all. I'm posting this question here as it pertains to my form but it could go in tables section as well. I developed a prototype app in Access and have just finished upscaling it to Sybase 12.5. When I open up the associated form to add records, I am unable to do so. The built in...

Greetings all, I have a question regarding subforms that are set to show continuous forms and how they can relate to each other. I have attached a jpg of what i'm trying to do, you may want to open it so you can follow along with what I will now explain. I have 3 subforms on a main form. The...

Greetings, I have two recordsets. One is based off a table that represents existing data, the other a table is based off an update file. I have DAO code that goes thru each record set and matches the recs on unique id. Once that is done I want to to compare the dates per record , per table...