Search results for query: *

SOLVED I followed the steps here http://stackoverflow.com/questions/3266542/ms-access-how-to-decompile-and-recompile , held shift to bypass startup code execution, then did a compile and repair on database. Not sure if it was the decompile flag that did it or simply running the compile/repair...

Thanks for the answers so far. Mdbdoc doesn't look like it exports the actual code from the module. It shows a list of modules and functions within those modules, but only displays the number of lines within each, not the code. I did come across this post on StackOverflow that has a script...

Last week I was modifying portions of two modules in an access 2010 db when the program crashed, and would crash every time I tried opening up the db thereafter. I was able to create a new database and import the tables and queries from the corrupted one, but when I tried to import the...

After a bit more debugging I've found that on the second run through the script, the main script passes a blank value as the roster end date to the sql function. At this point I don't think it has anything to do with the SQL, but either something with the way I wrote the code or a symptom of...

I've got a form with a table where the user enters an employee id into the first column and upon exiting the cell the below script is triggered which populates the other columns in the table with the employee's information. The problem I'm having is that the code works on the first row of the...

I'm about to start building an xml form with a table where the user enters a name and number of hours worked. The name field will be a drop down box with all authorized names. How do I prevent the user from entering the same user multiple times in the table? On a side note, how do I retrieve...

Does anyone have an idea? I've been stuck on this for three days and really want it to be resolved.

I get an error saying "Operation must use an updateable query." I'm not sure if my query is constructed correctly. It should update multiple employee records in the process table. Also the pay calendar table has multiple entries for each group, one for each paydate, but I'm not sure if the...

Hello all, I've been trying to figure out the logic for this, thought I had it, then couldn't write up the SQL correctly, so I'll ask here. I'm trying to send a letter to a list of employees notifying them of changes to the way they get paid. Details EMPL_INFO table contains employee ID and...

Thank you very much, works perfectly.

Forgot to add that if I use the code directly in a query designer it works fine, but when I add it to the control source the brackets are dropped from the code.

I'm having a problem making that work. My report looks at three tables, one to get employee information, another to get location information, and the last to get status information. If I use the code as is, I get an error saying it doesn't know which emplid to look for. So I tried to change your...

I'm not sure which forum to post this on since it overlaps several topics, but hopefully someone here can point me to the best solution to this problem. Here's the situation. I've got two tables: empl_info and location. Within the info table lies a field called location option which notifies...

Thanks, after taking out the where part in the function it works fine. I'm having another problem with sending the SQL through the function to DoCmd.TransferText, but I started another thread for that.

I have a button that will transfer the results of a query to a formatted text file. Here's the code,it works fine. Public Sub BatchButton_Click() Select Case MsgBox("Create Batch File?", vbYesNo) Case vbYes DoCmd.TransferText acExportFixed, "BFQ_EX_SPEC", "BATCH_FILE_QUERY"...

Ok I just started to change over my code to use functions and getting an error when trying to pass a function to DoCmd.OpenReport. The error is: Run-Time error '2212': Microsoft Office Access coudln't print your object. Here's part of the function Public Function GetSQL(category As String...

Can I send the function to a report with DoCmd.OpenReport? If so I can have select all queries for the reports and part of the click button code could send the where clause.

Ah, I see what you mean now. I'll try to change over to this, but one question. How would I call a function within a sql query and/or code?

Can you give me an example of how that would be done using where clause from my first post?

Thanks, that was an easier solution then what I was trying to do. Right now this is how the code works. 1. click on Print Letter button 2. report is opened and prints out all records based on a query. 3. After open report code, the sql is executed that updates the tables with the same where...