Search results

Hey all, I'd like to be able to compare data entered on two different dates (such as data from 6/4/08 and 7/3/08). I've kicked around a few things but can't seem to find a way to accomplish this. Any suggestions toward accomplishing this would be appreciated! The comparisons probably need...

Thanks for the input! I had to work with this a bit, but ultimately it pointed me in the right direction for getting done what I needed. Thanks again!

Yes, you are missing the & before your _. Try If (Me.CatCode = "Claim already paid/MBR rates no further entitlements/Duplicate Claim.") Or & _ (Me.CatCode = "Same city no entitlements / no per diem authorized in orders.") Then This should work.

Hey everyone, I'm working in a database with gets its data from a text file, then assigns values in a blank column to the imported data once imported. The problem is that once I start the import process for another file the recordset starts back at the beginning of the table and I overwrite...

Once again you came through for me with enough to get me on track for what I need done. I ended up writing an if statement that varies based on which of the two options is selected, then assigning the corresponding query. Thanks for the help again!

I've actually had instances where this would kind of happen to me, only to find out that my database had corrupted itself. I would make a backup before doing anything to correct the problem. You may also try making a new db and copying all your tables/queries/forms/reports/macros/modules and...

Hey everyone, I'm trying to generate a report that needs to have its record source based on what option (of 2) a user selects. A different query will be called depending on the selection. Any suggestions to help point me in the right direction would be great, because I seem to be running in...

You could disable warnings, then use MsgBox to create your own warning. Despite having warnings disabled the message box will still display.

As seems to be a common trend for me lately, I've solved my own issue shortly after posting it. Just changed the name of the Payor_Code column in one of my tables.

Hello everyone, I've got a pivotchart that uses information from a query for its data. I recently made a small adjustment in the data being taken in and now get the following error: "The specified field 'Payor_Code' could refer to more than one table listed in the FROM clause of your SQL...

I apologize again for the somewhat vague-ness of my description, but I did manage to get it to work through the Relationships. Don't quite ask me how it works, but it does so I'm going to go with it. Thanks again!

Hey all, I'm working on a database that has data in four columns in one table. What I need to do is take that data, compare, then replace it with data from a single column on another table if the code matches in either column. Just to help clarify, I've got two columns of code numbers in...

Those little plus signs indicate that the table entry is linked to another set of data located in another table through some Relationships connections. To view how the tables are connected, go to tools -> relationships. Typically, the items with the + next to them are primary keys for that...

Only thing I could think of is that the excel file you are importing has defined types in it and access has a different type defined for that particular column, which could cause a type mismatch. I don't think this normally would stop it from importing it and just saying that it didn't import...

Sorry I couldn't help point you exactly where you needed to go, haven't had a chance to work in access '07 yet, but glad you found what you needed!

I'm not sure if you can tell the wizard to stop producing macros, but you could always just convert the macro to VBA code through one of the menus. Not sure what version you are actual questions are relating to, but the version I'm using has this ability in the Tools -> Marco -> Convert Macro...

If you are looking for value in a console, the PS3 is the way to go. Considering it is practically a computer/media center on its own, plus a blu-ray player, its a simple decision, and considering a stand-alone bluray is still in the $350-$400 range, if you go with the 40GB model you're...

Hey all, I don't know if there is a way to help with this one, and it's going to be slightly vague in description, but I'm currently working on a database that imports a text file for its data. Problem is that sometimes it will import correctly and other times it will mess up like it is its...

I believe the method mentioned by agif can be done through the following: Go to the form design view, then right-click in the grey box in the upper left corner where the vert. and horiz. rulers meet and select properties. This should open the form properties window. If a window goes away...

Well, one way I can think of would be to have two buttons: one for view mode and one for edit. You could stack them if you wish and change their "Visible" properties according to which mode the user is in (cmdButton.Visible = True/False). Then in the VBA Code you can register their "On Click"...