Skip to content
Advertisement

Tag: ms-access

Custom String Conversion

I want to convert a string that can have two formats. Example 1090512300 to 9.5.123 1090501300 to 9.5.13 The first string (1090512300) will always have the same length but the second(9.5.123) string won’t. The conversion logic is as follows 1 xx yy zzz 00 So string 1 will be 1xxyyzzz00 and string 2 xx.yy.zzz where all zeros have been removed.

Parameterized queries + DoCmd.TransferSpreadsheet acExport

I need to export a large amount of complex data to an excel spreadsheet. To facilitate this, I have created several large queries. Now I’m looking to filter these queries based on date range and some other tidbits of information, but I am unsure how to do so. DoCmd.TransferSpreadsheet acExport, , “Overview_Agents_Query”, xlsxPath, True, “Agents” This is how I am

Find the timestamp of a unique ticket number

I have a table that looks like this: There are 400,000 rows. The ActivityNumber is a unique ticket number with the activity count attached. There are 4 teams. Each activitynumber is in the table. I need to calculate the average time taken between updates for each team, for each month (to see how each team is improving over time). I

C# win forms app hangs

The following code is for reading from an Access DB and transferring to a SQL DB. Can anyone tell me why this code just hangs after it is run ? I have a label that should change telling me the row that is being processed but the Form just sits and becomes unresponsive once I have clicked the button. Everything

Run-time Error 3131 Syntax Error in FROM clause

Tried scouring the forums for threads similar to mine but couldn’t really find anything that would lead me in the right direction. Basically I have a table that has the QA scores for each of the 10 regions and I am trying to populate a text box with a specific region’s score depending on the month. I was trying to

Advertisement