Search results

Mihail, I am a little confused as to where to place this code. It looks like there is a Public Function and also a private sub. Also, after reading through the thread it looks like this code re-links tables from other databases. I am trying to loop through all of my table objects, back end...

Pat, Thank you for your time. The code below pulls all the tables into the tblTableinfo table, but for the linked tables it puts a -1 in the tblRecordCount field. If I could get the tblRecordCount to update correctly, this code would be perfect. Dim dbs As DAO.Database, rst As DAO.TableDef...

Good Afternoon, I am trying to run some diagnostics on my database. I thought a good place to start would be to look at all of the tables, the number of records each table holds, and each table's size. I have been able to find plenty of code on the web that loops through each table and...

Hello, I have a form with 7 unbound text boxes on it. The code below is on an On Click event of a button. The code is supposed to look at all of the unbound text boxes, if they are null make them a 0, and then conduct a simple subtraction calculation. For some reason the Nz(stringhere,"0")...

Nice. That worked! I added the apostrophies. Thank you, pbaldy. You da man!

Thank you for the quick reply. I did come accross the link you sent when I was conducting my research a little earlier, but it was a little over my head. In addition, I did not see anything about the Eval() function within the link. I just tried placing the eval() around each of the criteria in...

Good Afternoon, I am in the middle of creating a function that populates two unbound text boxes on a form and then uses those unbound textboxes in a query (Total of 3 unbound text boxes - 2 are populated from this function). The saved query object is working fine when I manually execute it...

Good Morning and thank you in advance for any assistance provided - I have a main form, lets call it FrmMain. In addition, I have a subform on FrmMain that has a tab control on it (frmSubform). What I would like to do is on form load, reference the tab control that is on the subform, loop...

Hello, I am trying to create a small function that looks that a date field, finds the current calendar quarter, and then returns the previous quarter. I came up with the code below, however, because I subtract 1, when we are in quarter 1, the function/string returns 0. Any ideas how I can get...

Thanks, Pbaldy. THis worked. I am not sure why, but it worked. Logically it does not make sense to me. Thanks again! Tallman

Hello, I have the following code that checks to make sure associates, other than myself, are not accessing my Access database from the main share-drive location and that the associates are using a local copy on their desktop. The code was originally writtien so that I - the main developer -...

All - This works like a charm. Exactly what I needed. Thank you very much for your time! Tallman

Hello - I am using the following query to pull a list of all tables in my database that are connected using an ODBC connection: SELECT MSysObjects.DateCreate, MSysObjects.DateUpdate, MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE (((MSysObjects.Type)=4)); I need to take this...

Thanks for the reply, Gents. Bob - [ ]: Null did not work either. (In design view) MXAccessRookie - I will give it a look. Thanks to both of your for your help. Tallman

Hey Pbaldy, I am getting the "The expression you entered contains invalid syntax" error. I tried entering it in the design view of the query. Thank you, Tallman

Hey Plog - Thanks for the response. I need the whole field to be blank, even the header name. I dont think this is possible as it completely goes against table logic. I may need to find a workaround once the Excel file is created.

Hello, I need to run a query and export it to Excel in a certain format. The format needs to be something like: Account, blank1, blank2, Client_Name, Address, etc, etc The problem I am having is getting the blank columns to have blank headers. Is there a work around to get a column to be...

Jdraw - I really appreciate your help. I got the procedure to work on a double click event. For some reason it is still not working on the "on click" event. I am going to call it a day on this and use the double click. Thanks for your help, Tallman

:banghead:Column Heads = No :banghead:

Hey jdraw - Thanks for the assitance. What I am trying to do is click on one record at a time in the me.lstSchIds listbox. (I have it set as a "Simple" listbox) I would like the value or string value of the record selected set to a variable ( strSSchCode) This strSchCode variable is...